Forum Discussion
Help. Numbers are not adding up and I do not know why
dbrandone I did invent a DAX week number column that does not reset at the end of the year called Sequential: Sequential - Microsoft Power BI Community
dbrandone
Please the following measure:
VAR __WEEK = WEEKNUM ( TODAY () , 2)-1
RETURN
CALCULATE (
[Consent Rate],
'Date'[Week of Year] = __WEEK
)
dbrandone 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/547907Thanks Greg_Deckler ,
I went into the table view and manually filtered the data based on the filters in the measures for the totals measures that led to the consent rate. I did the math and they line up perfectly with the table. The table is correct, but the card measure is not.
dbrandone What is result you want in your card visual?
What is also odd is that I wrote a measure for last month and the number was right.