Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
when I select week= 2/8/2019 and Project = B
How can i achive this logic?
week | Emp id | Project | Utilization % | Utilization |
2/8/2019 | AVG_384 | A | 40 | Partially Utilized |
2/8/2019 | AVG_384 | B | 60 | Partially Utilized |
2/8/2019 | US_1 | A | 70 | Partially Utilized |
2/8/2019 | US_1 | B | 15 | Partially Utilized |
2/8/2019 | US_1 | C | 5 | Partially Utilized |
2/8/2019 | US_1 | D | 10 | Partially Utilized |
2/8/2019 | US_2 | B | 50 | Partially Utilized |
2/9/2019 | AVG_384 | A | 100 | Fully Utilized |
2/9/2019 | US_1 | B | 50 | Partially Utilized |
2/9/2019 | US_1 | D | 40 | Partially Utilized |
2/9/2019 | US_1 | E | 10 | Partially Utilized |
2/9/2019 | US_2 | E | 100 | Fully Utilized |
Solved! Go to Solution.
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
Thanks @v-danhe-msft
I tried, but I can't achieve my scenario
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
Hi @Anonymous ,
I could not understand your former sentense:
when I select week= 2/8/2019
when I select week= 2/8/2019 and Project = B
It seemed correct with my pbix, could you have downloaded it? I am confused about your requirements:
Pie chart want to show Partially Utilized=3
Could you please post your desired result picture if possible?
Regards,
Daniel He
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |