Forum Discussion
Subtraction each Category
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
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/
4 Replies
- amitchandak
Super User
Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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 .
- amitchandak
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/