topic Re: Ratio per type of classification in DAX Commands and Tips

Ratio per type of classification

Anonymous — Wed, 25 Nov 2020 14:59:44 GMT

Hi,

here is my table, i'm trying to get the ratio per type but doing something wrong.

So for example - last line result should be 494/778 = 63%

How do i fix my measure?

Much appreciated.

Thanks

amitchandak — Wed, 25 Nov 2020 15:28:39 GMT

Anonymous , Try like

divide([total classification count], calculate([total classification count], allselected(Table)))

Anonymous — Fri, 27 Nov 2020 15:16:57 GMT

Thank you Amit, works great