Divide by a Group

[Deepak3Arora]

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?

[jennratten · Accepted solution]

Hello - I have attached a sample pbix demonstrating how you can achieve the result.

[v-jingzhang · Accepted solution]

Hi @Deepak3Arora 

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.

[Deepak3Arora]

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

[jennratten · Accepted solution]

Hello - I have attached a sample pbix demonstrating how you can achieve the result.