Percentage Measure (I'm embarrassed to even be asking this)

[josephliverpool]

I have a table in Power BI titles 'Case Details' which has a column called 'Case Type'.

I want to write a measure which will calculate the percentage for each case type which makes up the total number of rows.

I appreciate that this is really simple yet I can't get it to work!!!

[anmolmalviya05]

Hi @josephliverpool, Hope you are doing good !

please try the below measure:

Case Type Percentage =
DIVIDE(
COUNTROWS('Case Details'),
CALCULATE(COUNTROWS('Case Details'), ALL('Case Details'))
)

[dk_dk · Accepted solution]

Hi @josephliverpool 

The easiest way to do this is:

Add a column from your table to the visual and select Count aggregation. Then Show value as % of grand total.

Alternatively you can set up a measure that looks like this:


Measure =


VAR casetype = MAX('Case Details'[Case Type)

VAR totCount = COUNTROWS(ALL('Case Details'))
VAR typeCount = CALCULATE(COUNTROWS('Case Details'),'Case Details'[Case Type] = casetype)

RETURN
typeCount/totCount



format as % and it should work


Hope this helps!

[Selva-Salimi]

Hi @josephliverpool 

you can write a measure as follows:

percentage:= sum( your_value) / calculate(sum(your_value) , all(your_table))

If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.