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 have multiple years in my data set and need to calculate the total % by the indiviual row for that given year. I've created a measure to give me the total for 2022, 2023. However, when I create the meausure for the % each row will give me 1.00. In reading about row calculations it looks like countrows needs to be in the measure. When I've tried different things it returns a syntax error.
HI @dajensen123 ,
It seems like a common issue when measure expression calculates on multiple level aggregates. I’d like to suggest you can refer to the Greg’s blog to add a variable with SUMMARIZE function to handle the first level and use iterator function to apply the second level.
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
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 |
---|---|
43 | |
20 | |
20 | |
16 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |