topic Re: Calculating percentage by group in DAX Commands and Tips

Calculating percentage by group

ConsatSudbury — Mon, 03 Oct 2022 00:05:50 GMT

I need a DAX measure for power bi to calculate the percentage of times each "Journey Name" is "On Time" as opposed to "Late" weighed against itself only. As an example, I have the left table as my data and I need to be ale to get the result in the right table.

Re: Calculating percentage by group

amitchandak — Mon, 03 Oct 2022 02:20:15 GMT

ConsatSudbury , You have to create measure like

divide(Count(Table[Journey Name]), Calculate(Count(Table[Journey Name]), filter(Table, Table[EarlyLate] = "On Time")))

Re: Calculating percentage by group

v-easonf-msft — Mon, 03 Oct 2022 07:25:04 GMT

Hi， ConsatSudbury

amitchandak 's formula needs to be adjusted, the denominator needs to be placed above the numerator.

% On Time = DIVIDE ( CALCULATE ( COUNT ( 'Table'[Variance] ), FILTER ( 'Table', 'Table'[EarlyLate] = "On Time" ) ), COUNT ( 'Table'[Variance] ) )

Best Regards,
Community Support Team _ Eason

Re: Calculating percentage by group

ConsatSudbury — Tue, 04 Oct 2022 14:11:36 GMT

Thanks v-easonf-msft For some reason, it does not work for my steup. I try to reply and attach my .pbix but I get an error that file .pbix is not supported. Not sure if this link will work.

https://consatdataab-my.sharepoint.com/:u:/g/personal/robert_gauthier_consat_se/EVxWEBBJAU9BkzRFAQUl6-8Byx01oRLaG8IVZxti7Z-1xA?e=eRG0sA

Re: Calculating percentage by group

v-easonf-msft — Wed, 19 Oct 2022 07:41:05 GMT

Hi, ConsatSudbury

I have checked the pbix. There is no problem with the formula, you may need to check "show value as no calculation".

Best Regards,
Community Support Team _ Eason