Forum Discussion
Solved
Unexpected output - sumx
Hi everyone, I don't understand the result of the Total row (I expect it was 4) Here the data: Anyone help me?
Hi,
I recommend reading this article by SQLBI about the total row: https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/
The behaviour of totals is a bit wonky in Power BI.
For a solution try something like this:Dax:
Measure 29 =var _mdate = CALCULATE(MAX('Table (18)'[date]),ALL('Table (18)'[date])) return
CALCULATE(SUM('Table (18)'[value]),'Table (18)'[date]=_mdate,ALL('Table (18)'[date]))
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
ValtteriN
Community Champion
Community ChampionHi,
I recommend reading this article by SQLBI about the total row: https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/
The behaviour of totals is a bit wonky in Power BI.
For a solution try something like this:
Dax:
Measure 29 =
var _mdate = CALCULATE(MAX('Table (18)'[date]),ALL('Table (18)'[date])) return
CALCULATE(SUM('Table (18)'[value]),'Table (18)'[date]=_mdate,ALL('Table (18)'[date]))
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
I'm sorry but if I changed the 4th row to December 28th, Total row = 2 (not as I expect). I expect it get the newest value of each Category and return 4