Forum Discussion
Calculation within Scaling model
Hi, I'm trying to implement a calculating "Scaling Modell" and do not find a solution how to deal with it. Example : SUM of Sales ist 1'234 and I'm willing to use that value to determine...
Hopefully something like this helps.
1. Create a Total Sales Measure something like this:
Total Sales Amount =
CALCULATE(
SUM(Sales[Total Sales Amount]))
2. Create a new column something like this:
Resulting Rebate =
If(
[Total Sales Amount]>=Scaling_Table[Sales] ,
Scaling_Table[Rebate],
BLANK()
)
3. Insert a card and enter the Resulting Rebate and Show only the Last Value.. You can also create a measure that gives you the max value.
Thank you very much Bmejia, I somehow found out how to deal with your input 🙂 and it is working.
Anyhow my issue now is that I cant apply 4 different filters (Calender ranges(variable), and different types of flags) on this calculation and I have to find out if I can handle it with the function keepfilteers.
Kind Regards