Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there!
I have two measures, [Promo Vol] and [Total Vol] - you can see the results in this table
I just want to create another measure that will sum up the [Total Vol] but ONLY in cases where [Promo Vol] > 0
So in this case the output value I'm looking for is £334,948 (i.e. sum of everything in [Total Vol] except the last two rows because the Promo Vol is 0
Does anyone have any suggestions?
Thanks
Alex
Solved! Go to Solution.
@Anonymous , Try a measure like
sumx(values(Table[Date]), if([Promo Vol] > 0, [Total Vol],blank()))
@Anonymous , Try a measure like
sumx(values(Table[Date]), if([Promo Vol] > 0, [Total Vol],blank()))
Legend, thank you! 😘
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |