category Subtraction row wsie

[Anonymous]

Hi Team,

I need "Remaining UID Stock" column result,

each category subtract with UID (sum of uique UID name)

 (Inv Date is separate table)

Prod_Total -> Prod_Total = CALCULATE(
VAR MaxDate = MAX ( 'INV DATE'[Date] )
RETURN
CALCULATE (
sum('DIM'[Qtd],
'INV DATE'[Date] <= MaxDate,
ALL ('INVOICING DATE')
)
)
Stock -> DIVIDE([Total UID Stock],[Qtd])

Thanks,

KV's

[Anonymous]

DIM Stock, Prod_Total both are calculated value,
Slicer -> DIM date based on dynamic result need

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

The data you provided is incomplete,I guess you wanna get a result as below:

If so,you could try to modify your measure as below:

Prod_Total -> Prod_Total = CALCULATE(
VAR MaxDate = MAX ( 'DIM'[Date] )
RETURN
CALCULATE (
sum('DIM'[Qtd]),
FILTER(ALL('INV DATE'),'INV DATE'[Date] <= MaxDate,
)
)

Or check my .pbix file attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format?