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+15+5+10 =100%)
  • US_2 is Partially Utilized (50%)

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

  • AVG_384 is Partially Utilized (60%)
  • US_1 is Partially Utilized (15%)
  • US_2 is Partially Utilized (50%)

How can i achive this logic?

 

 

weekEmp idProjectUtilization %Utilization
2/8/2019AVG_384A40Partially Utilized
2/8/2019AVG_384B60Partially Utilized
2/8/2019US_1A70Partially Utilized
2/8/2019US_1B15Partially Utilized
2/8/2019US_1C5Partially Utilized
2/8/2019US_1D10Partially Utilized
2/8/2019US_2B50Partially Utilized
2/9/2019AVG_384A100Fully Utilized
2/9/2019US_1B50Partially Utilized
2/9/2019US_1D40Partially Utilized
2/9/2019US_1E10Partially Utilized
2/9/2019US_2E100Fully Utilized

 

 

Need Help

4 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft 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

  • 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
      Microsoft 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

    • v-danhe-msft's avatar
      v-danhe-msft
      Microsoft 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