Subtraction each Category

[Anonymous]

Hi Team,

Remaining Stock calculation wrong, I need to subtract Prod_Total 2 based on each "UID in Stock" row wise,
Note: UID in Stock, Prod Total 2 both are new measures values, 
UID in Stock = [x]*[y]
Prod Total 2 = CALCULATE([Prod_Total],ALLEXCEPT('Table','Table'[UID]))
Remaining Stock = ? (nee your help)

KV's

[amitchandak · Accepted solution]

@Anonymous , ALLEXCEPT means that filter will taken all other will be ingonred

Try

Total Prod Val = CALCULATE([Prod_Val],ALLEXCEPT('Table','Table'[Month Year]))

refer: https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/

[Anonymous]

Hi @amitchandak ,

Thanks for the soluction,

How do I split sum UID wise like 44.OIU and 67 RTY

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Hi @amitchandak ,

Prod_Val = SUM('UID'[Production])*1.1
Prod_Stock = SUM('UID'[Stock])*1.2
Total Prod Val = CALCULATE([Prod_Val],ALLEXCEPT('UID','UID'[UID]))

Data look like below and date slicer selected Jan month but Total Prod val showing overall UID sum, but I'm expected Jan month sum .