division/percentage

[matts29]

Hi 

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

🙂

[Anonymous · Accepted solution]

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.

[matts29]

great thats amazing 🙂