cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vengadeshpalani Regular Visitor
Regular Visitor

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?

 

a.png

 

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Create calculated dimension field based on measure value

Hi @vengadeshpalani ,

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:

1.PNG

1.PNG

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

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Community Support Team
Community Support Team

Re: Create calculated dimension field based on measure value

Hi @vengadeshpalani ,

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:

1.PNG

1.PNG

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

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
vengadeshpalani Regular Visitor
Regular Visitor

Re: Create calculated dimension field based on measure value

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
Community Support Team
Community Support Team

Re: Create calculated dimension field based on measure value

Hi @vengadeshpalani ,

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Create calculated dimension field based on measure value

Hi @vengadeshpalani ,

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.