Total value in DAX is not matching with row total

[Velvetine27]

Hi,

I wrote up few DAX queries to get total stock quantity. First query is this :

SumRunningQuantity =

VAR lowest_date  =  CALCULATE(MIN(TY[ROWNUM2]),GROUPBY(TY, TY[Plant]))

RETURN

  CALCULATE(SUMX(TY,TY[RunningQuantity]),FILTER(TY, TY[ROWNUM2]=lowest_date))

Second query is :

TotalRunningQuantity =

SUMX(

    SUMMARIZE(TY, TY[Material],

    "Lowest Row",[SumRunningQuantity])

    ,[SumRunningQuantity])

ROWNUM2 is how I put the dates in order because I only want to capture the quantity at the latest date depends on date slicer. 

The correct total should be 28,692,069.52. Appreciate if someone can help me on this.

Thanks !

[Anonymous · Accepted solution]

Hi @Velvetine27 ,

Create a new measure by using ISINSCOPE() or ISFILTERED() function.

ISINSCOPE function (DAX) - DAX | Microsoft Learn

ISFILTERED function (DAX) - DAX | Microsoft Learn

Measure = IF(ISINSCOPE([Plant]),[TotalRunningQuantity],SUMX(ALLSELECTED(yourtable),[TotalRunningQuantity]))

[Anonymous]

Refer to this link. Maybe it will help you.

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Matrix-row-total-not-matching-values/m-p/2216...