Percentage calculation of row total in Power Bi

[gk124]

I have this data table & I want to create a matrix in Power Bi 

which calculates grade count & grade count % as shown below

What DAX measure will be used to do the above calculation.

[Anonymous · Accepted solution]

Hi @gk124 ，

You could create the following measure.

Count% = DIVIDE(COUNT('Table'[Result]),CALCULATE(COUNT('Table'[Result]),FILTER(ALLSELECTED('Table'),[Month]=MAX('Table'[Month]))))

Best Regards,

Stephen Tao

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

[gk124]

Waaoo..
This is super cool. Thanks a ton!!

[gk124]

Expecting result should be-

Please help !!

[amitchandak]

@gk124 , Usually % of grand total should

divide(countrows(Table) , calculate(countrows(Table), allselected()) )

or

divide(countrows(Table) , calculate(countrows(Table), all()) )

and subtotal is

divide(countrows(Table) , calculate(countrows(Table), removefilters(Table[Name])) )

or

divide(countrows(Table) , calculate(countrows(Table), allexcept(Table, Table[Month])) )

Percent of Total and Percent of SubTotal

https://www.youtube.com/watch?v=6jTildcV2ho

[gk124]

Hi Amit,
Thanks for reply but both the measures are returning 0 as a value. Can you please use the data in power bi and then share the measure.