Forum Discussion
Solved
Help with DAX
Hi All, I have a following table called Table1, Model Code MSRP LC FJ11 1392000 FJ16 1580000 188000 FJ7 1762000 182000 FJ8 1912000 150000 FJ15 1937000 25000 FJ...
Hi, Singh_Yoshi
I simply modeled a portion of the data and hope it fits your situation.
Pre MSRP = CALCULATE(MAX('Table'[MSRP]),FILTER(ALL('Table'),[MSRP]<SELECTEDVALUE('Table'[MSRP])))LC = IF([Pre MSRP]=BLANK(),BLANK(),SUM('Table'[MSRP])-[Pre MSRP])Sum Measure = SWITCH(TRUE(), SELECTEDVALUE('Table'[Model Code])="FJ11",BLANK(), SELECTEDVALUE('Table'[Model Code])="FJ16",[FJ11-16], SELECTEDVALUE('Table'[Model Code])="FJ7",[FJ16-7], SELECTEDVALUE('Table'[Model Code])="FJ8",[FJ7-8], SELECTEDVALUE('Table'[Model Code])="FJ15",[FJ8-15], SELECTEDVALUE('Table'[Model Code])="FJ12",[FJ15-12])Result1 = [LC]-[Sum Measure]Result2 = DIVIDE(SUM('Table'[MSRP]),[Pre MSRP]+[Sum Measure]*100)Is this the result you expected?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Difference =
VAR MeasureSum = SWITCH(
TRUE(),
[Model Code] = "FJ11-16", -1674,
[Model Code] = "FJ16-7", 70650,
[Model Code] = "FJ7-8", 176150,
[Model Code] = "FJ8-15", -68150,
[Model Code] = "FJ15-12", 28500
)
RETURN
[LC] - MeasureSum
Percentage =
DIVIDE([Difference], [LC], 0)