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 ,

I could not understand your former sentense:

when I select week= 2/8/2019

  • AVG_384 is Fully Utilized (40+60= 100%)
  • US_1 is Fully Utilized (70+15+5+10 =100%)
  • US_2 is Partially Utilized (50%)

when I select week= 2/8/2019 and Project = B

  1. AVG_384 is Partially Utilized (60%)
  2. US_1 is Partially Utilized (15%)
  3. US_2 is Partially Utilized (50%)

It seemed correct with my pbix, could you have downloaded it? I am confused about your requirements:

  • 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

Could you please post your desired result picture if possible?

Regards,

Daniel He