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.
Hello everyone,
I have a problem calculating the total in a matrix visualization when using a measure with an if statement.
I created this simplified model to ask this doubt (that’s why some numbers don’t make sense, it’s just to express it with more clarity.
The goal is to create a measure that offers a 50% discount if the customers bought more than 40% regarding their target and no discount otherwise. Except just for customer C who will receive a 20% discount if he bought more than 10%.
I send the screens of what I have tried so far. I created the measure that shows the correct discount for every customer but it doesn’t show the correct amount for the total.
Base:
Matrix and discount measure created:
Thanks in advance!
Solved! Go to Solution.
Hi @Anonymous
You can create new measure
SUMX ( VALUES (base[customer]), [discount] )
It worked perfectly, thanks a lot!!
Hi @Anonymous
You can create new measure
SUMX ( VALUES (base[customer]), [discount] )
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |