Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone
I'm using the following Measure to COUNT the number of contacts who are aged between 41 & 60 years of age over around 125,000 records. The 125,000 records contain a range of ages including NULLs.
It's taking FOREVER, and I wondered if there's a better way of doing this?
Solved! Go to Solution.
To clarify, you could create a calculated column that contains each age group (e.g., 21-40, 41-60). If you have an alternate grouping (e.g., 21-30, 31-40), you could create a second calculated column for this grouping.
Proud to be a Super User!
Try this measure:
age41-60 =
CALCULATE (
COUNTROWS ( contact ),
contact[sic_age] >= 41
&& contact[sic_age] <= 60
)
You could also create calculated columns for each age group.
Proud to be a Super User!
To clarify, you could create a calculated column that contains each age group (e.g., 21-40, 41-60). If you have an alternate grouping (e.g., 21-30, 31-40), you could create a second calculated column for this grouping.
Proud to be a Super User!
User | Count |
---|---|
128 | |
108 | |
99 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |