Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Try this Measure
Measure =
DIVIDE(
DISTINCTCOUNT( 'Table'[ID] ),
CALCULATE(
DISTINCTCOUNT( 'Table'[ID] ),
ALLSELECTED()
)
)
Try this Measure
Measure =
DIVIDE(
DISTINCTCOUNT( 'Table'[ID] ),
CALCULATE(
DISTINCTCOUNT( 'Table'[ID] ),
ALLSELECTED()
)
)
This helped a lot. Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |