Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
v-danhe-msft
Employee
Employee

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:

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.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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

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

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.

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

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.
v-danhe-msft
Employee
Employee

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:

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.