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

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
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