Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
For some reason my Active weeks/months measure grand total is wrong. Does anyone know, how to fix it?
Measure for calculating active weeks/months:
Thanks in advance!
Solved! Go to Solution.
@ReikoK First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
@ReikoK First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
It is a column, where are name of months or number of weeks. I have made a filter, which allows me to change between weeks and months
Here is my relationship model:
man. calendarweek then is represented the month come on 🙂
you are iterating over the values of months, so just 12 months, regardless the year.
If you wanna keep that approach you need to add a column on that table with Year-Month then sumx over this column.
You get 8 as a result because regardless the year you have 8 month with a 1
what is this? 'Perioodilisuse filter'[Name]
anyway your measure is wrong, that measure can't work. paste the correct one
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |