Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create calculated dimension field based on measure value

Hi all   I want to show a Pie chart  Dimension=Utilization staus Measure = No of Emp Id   Ex: when I select week= 2/8/2019 AVG_384 is Fully Utilized (40+60= 100%) US_1 is Fully Utilized (70...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous ,

    Based on my test, you could refer to below steps:

    Create below measure:

    Measure = CALCULATE(SUM(Table1[Utilization %]),ALLSELECTED(Table1[Utilization]))

    Create visual and add related fields, you could see the correct result:

    You could also download the pbix file to have a view.

     

    Regards,

    Daniel He

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks v-danhe-msft 

 

I tried, but I can't achieve my scenario 

  • when I select week= 2/8/2019 
    • Pie chart want to show Fully Utilize =2 and Partially Utilized=1
  • when I select week= 2/8/2019 and Project = B 
    • Pie chart want to show Partially Utilized=3
v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

 

Regards,

Daniel He