Wrong grand total

[ReikoK]

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: 

Active weeks/months = CALCULATE(SUMX(VALUES('Perioodilisuse filter'[Name]);IF([Total GRP] > 0; 1)))

Thanks in advance!

[Greg_Deckler · Accepted 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]

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:

[Gabry]

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

[Gabry]

what is this? 'Perioodilisuse filter'[Name]

anyway your measure is wrong, that measure can't work. paste the correct one