Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Product | Sales | Category | Coefficient |
P1 | 100 | Food | 0.2 |
P2 | 50 | Leisure | 0.4 |
P3 | 200 | Food | 0.2 |
P4 | 300 | Leisure | 0.4 |
P5 | 400 | Leisure | 0.4 |
I have a table like this and I create measures like these:
EligibleCategory = IF(MAX(Table[Category]) IN {"Leisure"}, "YES", "NO")
EligibleSales = IF(0.5*SUM(Table[Sales]) >= 50, "YES", "NO")
Taxes = IF(EligibleSales = "YES" && EligibleCategory = "YES", MAX(Table[Coefficient]) * SUM(Table[Sales]), 0)
With these measures, I should get something like this:
Product | Sales | Category | Coefficient | EligibleCategory | EligibleSales | Taxes |
P1 | 100 | Food | 0.2 | NO | YES | 0 |
P2 | 50 | Leisure | 0.4 | YES | NO | 0 |
P3 | 200 | Food | 0.2 | NO | YES | 0 |
P4 | 300 | Leisure | 0.4 | YES | YES | 120 |
P5 | 400 | Leisure | 0.4 | YES | YES | 160 |
Total | 950 | YES | YES | 280 |
Most importantly, I want to know how to write my measures in a way that the total comes out to be 280 (sum of visible rows) instead of computing the measures on the aggregate result and giving the wrong total.
Solved! Go to Solution.