Percentage of count

[supergallager34]

Hello, 

I am trying to figure out how to calculate percentage of rows because I need it for another calculation. I  have a sample table that looks like this, 
IDGender

101	M
102	F
103	M
104	F
105	F
106	F
107	M
108	M
109	M
110	M
115	F

I am trying to figure out how this is calculated my actual table has a lot of duplicates and I would the denominator to be dynamic and taking in the distinct count of the IDS. Please let me know what the possible solution would be. Thank you

[Mariusz · Accepted solution]

Hi @supergallager34 

Try this Measure

Measure = 
DIVIDE(
    DISTINCTCOUNT( 'Table'[ID] ),
    CALCULATE(
        DISTINCTCOUNT( 'Table'[ID] ),
        ALLSELECTED()
    )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[supergallager34]

This helped a lot. Thank you!