Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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 , 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 ,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 .
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |