Calculate percentage of the total

[Anonymous]

Hey,

I would like to calculate a percentage of the total. Like you can see in the picture the last row has a 1 or a 0. I want to know how many times it gives 1 as result and compare this to the total amount of rows. So I get a percentage out of it. 
The result in this example must give: 53% (8 times 1 / the total 15)

Thanks for helping!

[isabella · Accepted solution]

Hi @Anonymous 

I did a local test ，hope this helps.

create a measure :

measurepecentage = CALCULATE(COUNTROWS('tabletest') ,FILTER('tabletest',[voorbeeld(0/1)]="1"))/CALCULATE(COUNTROWS('tabletest'),ALL('tabletest'))

set the measure format:

use the measure in a card :

Best Regards,

Community Support Team _Isabella

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jp2050]

Hi,

There are multiple ways to go about it - but what you could do is select "Quick Measure" on the ribbon, select the division calculation, drag "wo_nummer" field in as numerator (should populate to "Count of wo_nummer," change the type/make sure it's count and not sum if not), and then drag the sum of the 0/1 column field in as denominator. Change the result to % type and you should get your desired result.