Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Guys,
I am trying to Divide a data by a Sum of Data grouped on 2 columns.
Below is my Data:
DateTypeResult
1-Sep-22 | Type A | Good |
2-Sep-22 | Type A | Bad |
3-Sep-22 | Type A | Good |
4-Sep-22 | Type B | Bad |
5-Sep-22 | Type B | Good |
12-Oct-22 | Type B | Bad |
13-Oct-22 | Type B | Good |
14-Oct-22 | Type C | Good |
15-Oct-22 | Type C | Good |
Result Needed is:
%age of Good | ||
Matrix | September'22 | October'22 |
Type A | (2/3)*100 = 66.66666667 | 0 |
Type B | 50 | 50 |
Type C | 0 | 100 |
How can I Achieve it?
Solved! Go to Solution.
Hello - I have attached a sample pbix demonstrating how you can achieve the result.
Try this measure
Also, add Month column to the table. Sort Month column by Month number column.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Try this measure
Also, add Month column to the table. Sort Month column by Month number column.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hello @jennratten ,
Thanks for the Details.
But I just need Percentage of Good, Divide by that current group(Based on Type and Month) Total.
For eg : Sepetmber Type A% - 66.6%
Sorry If I could not detail it out well earlier.
Regards
Deepak