locked
Dax expression for calculating percentage RRS feed

  • Question

  • Hi ,

    I have a "ProjectResource" table like below,

    ProjectID,Designation,ResourceID

    ProjectA, Development,1

    ProjectB,Development,2

    ProjectA,Quality Assurance,3

    ProjectB,Quality Assurance,4

    ProjectA,Quality Assurance,5

    ProjectB,Manager,6

    I need a DAX expression to show percentage of Designation(resource)  for each project in a Power BI pie chart.

    output like: when filter based on Project wise,

    Project A - Total Resource = 3,Development = 2/3,Quality Assurance = 1/3 -> this percentage values show in pie chart

    Project B - Total Resource = 3, Development = 1/3,Quality Assurance = 1/3,Manager=1/3 -> this percentage values show in pie chart.

    Pls suggest a DAX expression for this above requirement

    Thanks

    R.B

    Wednesday, January 27, 2016 12:56 PM

Answers