topic Re: division/percentage in DAX Commands and Tips

division/percentage

matts29 — Tue, 13 Feb 2024 11:36:35 GMT

Can someone help please?

I have a column (column a) contains rows of the value = 1 or 2 or 3. I would like to have the percentage displayed in a card where Column a ( equals 2 and 3) / Column A (count of all the numbers in this column)

Thanks

🙂

Re: division/percentage

Anonymous — Wed, 14 Feb 2024 01:31:38 GMT

Hi matts29

Try the following dax

Percentage of 2 and 3 = DIVIDE( COUNTROWS(FILTER('Table', 'Table'[value] = 2 || 'Table'[value] = 3)), COUNTROWS('Table'), 0 ) * 100

This is the result you want

Best Regards,

Jayleny

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

Re: division/percentage

matts29 — Wed, 14 Feb 2024 12:28:41 GMT

great thats amazing 🙂