Forum Discussion
Cumulative totals (rows)
What is the name of the column you used to give the Year values to the matrix (the field in the Columns field well). I assumed you have a column that has year values in it. Do you have an auto date hierarchy (i.e., you get .[Day], .[Month], etc. after your Date columns?). If not already, please put the same column that is currently on your matrix visual to get Year values inside the VALUES( ) in that measure.
Regards,
Pat
Anonymous this is what I will do, based on my measures, you can apply the same to your measure or the one you are using
DYTD = IF ( ISINSCOPE ( 'Calendar'[Year] ), TOTALYTD ( [Sales], 'Calendar'[Date] ), [Sales] ) * DIVIDE ( [Sales], [Sales] ) DYTD = SUMX ( VALUES ( 'Calendar'[Year] ), TOTALYTD ( [Sales], 'Calendar'[Date] ) ) * DIVIDE ( [Sales], [Sales] )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Super UserAnonymous this is what I will do, based on my measures, you can apply the same to your measure or the one you are using
DYTD =
IF ( ISINSCOPE ( 'Calendar'[Year] ), TOTALYTD ( [Sales], 'Calendar'[Date] ), [Sales] ) *
DIVIDE ( [Sales], [Sales] )
DYTD =
SUMX ( VALUES ( 'Calendar'[Year] ), TOTALYTD ( [Sales], 'Calendar'[Date] ) ) *
DIVIDE ( [Sales], [Sales] )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
parry2k Thanks Parry.
That fixed the repeating values. But still an issue with the row totals.
There are two years here. 2019 2020. The 2020 column, ends correctly in July (as we have no orders past July).
So those blanks are correct....but you can see the value of July 2020 is still being added to the other months in 2019. Not sure how to fix or why it is happening?
- parry2k
Anonymous I think you need to define what you are trying to achieve, your problem was that total doesn't work and now what you are mentioning is totally different stuff. Unfortunately, DAX calculations don't work like that. You have to be very specific about what you want to achieve. What you are now asking is totally different?
Hi parry2k
My mistake! I was not looking at it correctly. But yes, its clear now. Thanks for your help!