Solved: how to get percentage based on value in column

Anonymous · ‎10-31-2020

How to get value of percentage of collumns in a measure for data below

I want to achive

% of count = (Total count for value -0) / Total count ) * 100

for example above result should be = (4/10 ) * 100

Fowmy · ‎10-31-2020

@Anonymous

Did get it right I believe, if you want to count records with zero and divide **bleep** by total count then use this measure:

Measure1 = 
DIVIDE(
    CALCULATE( COUNTROWS( Table ), Table[Filled] = 0),
    COUNTROWS( Table )
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

Did I answer your question? Mark my post as a solution! and hit thumbs up

Fowmy · ‎10-31-2020

@Anonymous

Did get it right I believe, if you want to count records with zero and divide **bleep** by total count then use this measure:

Measure1 = 
DIVIDE(
    CALCULATE( COUNTROWS( Table ), Table[Filled] = 0),
    COUNTROWS( Table )
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

Did I answer your question? Mark my post as a solution! and hit thumbs up

how to get percentage based on value in column