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.
PercentCoverage = ROUND(SUM(coverage_metrics[records_populated]) / (SUM(coverage_metrics[records_populated]) + SUM(coverage_metrics[records_missing])),2) * 100
I would like to be able to count all the values that are:
Solved! Go to Solution.
Set up a new table, e.g. Segments, which contains the min and max values for the range and the text you want to display. Then you can create a new measure
Num in segment =
SUMX (
Segment,
COUNTROWS (
FILTER (
'Table',
[PercentCoverage] >= Segments[Min value]
&& [PercentCoverage] < Segments[Max value]
)
)
)
Set up a new table, e.g. Segments, which contains the min and max values for the range and the text you want to display. Then you can create a new measure
Num in segment =
SUMX (
Segment,
COUNTROWS (
FILTER (
'Table',
[PercentCoverage] >= Segments[Min value]
&& [PercentCoverage] < Segments[Max value]
)
)
)
Thank you, i tried your suggestion but i'm getting rather large results, instead of 30 for the 100% segment i'm getting 88500+. I've included a screenshot of everything i've done.
As you can see on the table visual on the left the total number of rows is only 63 and the number of rows that have '100 Percent Coverage' is 30 out of the 63 rows in that visual.
Can each entry in data_field appear more than once? If so then you can replace the 'coverage_metrics' line with VALUES('coverage_metrics'[data_field]) and that will then only work on the unique values rather than counting duplicates
Brilliant! That fixed it. Thank you so much for your help 🙂
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |