Solved: Re: Total value in DAX is not matching with row to...

Velvetine27 · ‎11-15-2022

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 !

v-jayw-msft · ‎12-01-2022

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

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

v-jayw-msft · ‎12-01-2022

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

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

shreyamukkawar · ‎11-17-2022

Refer to this link. Maybe it will help you.

Total value in DAX is not matching with row total