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 Community: I am trying to understand why the negative percent (discount) values are creeping into my table below. I have this measure used in the chart below, and when I select the 20% or Less column, it is working correctly, however there are some negative percentages that show up in the table which is dynamically being filtered from the column chart.
Is there something wrong with my SWITCH statement?
Solved! Go to Solution.
@HotChilli That was a good tip and got me in the right direction. Added a few more statements and perfecto. This was the final measure that allowed for the correct grouping whether in a column chart or table.
Investigate which cohort negative discounts get assigned to.
The easiest way is to add a table visual with discount and discount cohort. (as long as they don't aggregate).
Which cohort do you expect?
@HotChilli That was a good tip and got me in the right direction. Added a few more statements and perfecto. This was the final measure that allowed for the correct grouping whether in a column chart or table.
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |