Calculating percentage by group

[ConsatSudbury]

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.

[v-easonf-msft]

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

[ConsatSudbury]

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/EVxWEBBJAU9BkzRFAQUl...

[v-easonf-msft · Accepted solution]

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

[amitchandak]

@ConsatSudbury , You have to create measure like

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