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 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!
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |