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.
I hope some can help me with this one.
I'm having some trouble with calculating a value based on Tiers of spend and if it needs to be a sum or a general value.
I have vendor spend calculated on a Measure but I need to work out the actual tier value as well.
Supplier Number | Unit | Tier 1 Lower | Tier 1 Upper | Tier 1%
1 Spend 0 375 0.01
2 Fixed 0 5 1000
My Tiers go upto 7 but they are different on each row and the Fixed Unit always need to give the Value not a sum.
Solved! Go to Solution.
@Anonymous
You may try SWITCH function.
https://community.powerbi.com/t5/Desktop/SWITCH-TRUE-vs-SWITCH-Colname/m-p/544785#M256016
@Anonymous
You may try SWITCH function.
https://community.powerbi.com/t5/Desktop/SWITCH-TRUE-vs-SWITCH-Colname/m-p/544785#M256016
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 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |