Unexpected output - sumx

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/