Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I have the above table on power bi.
Description is a category of products, Quantity to expire is a measure from Stock table, Forecast is another measure from Forecast table. Risc BDD is Quantity-Forecast.
How can I show as Total on Risc BDD column only the 617 not all the aggregation which shows -11581 result.
Thank you!
Solved! Go to Solution.
@ekoland88 , I think this should work
if([RiskBDD]>0, [RISK BDD],0)
But if do not get a grand total
Try sumx(table,if([RiskBDD]>0, [RISK BDD],0))
or sumx(values(table[description]),if([RiskBDD]>0, [RISK BDD],0))
@ekoland88 , Assuming [RISK BDD] is a measure
sumx(table,if([RiskBDD]>0, [RISK BDD],0))
Yes, RiskBDD is indeed a measure but what table should I use in the sumx?
@ekoland88 , I think this should work
if([RiskBDD]>0, [RISK BDD],0)
But if do not get a grand total
Try sumx(table,if([RiskBDD]>0, [RISK BDD],0))
or sumx(values(table[description]),if([RiskBDD]>0, [RISK BDD],0))
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |