Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi I have struggled for few days now reading posts and trying all variations on how to build a conditional DAX and no matter which way i do it, it doesn't give me the result that I'm after.....
My original DAX is calculating diff sections as per below and what I'm after is one DAX that can change the colours accordingly, posted below too
Solved! Go to Solution.
Hi @michaelag ,
try this.
Selected_Actual_Vaues_Performance%_Colour =
VAR CurrentItem =
SELECTEDVALUE ( 'Performance % Template'[Perforamnce %] )
RETURN
SWITCH (
TRUE (),
CurrentItem = "Revenue %", IF ( [All_Income_VarPerc] <= 0.00, "Red", "Green" ),
CurrentItem = "Parts Mix %", IF ( [Parts_RatioPerc_Var] >= 0.00, "Red", "Green" ),
CurrentItem = "Panel GP %", IF ( [Panel_GP_Perc_Var] <= 0.00, "Red", "Green" ),
CurrentItem = "Parts GP %", IF ( [Parts_GPPerc Var] <= 0.00, "Red", "Green" ),
CurrentItem = "Paint GP %", IF ( [Paint_GPPerc_Var] <= 0.00, "Red", "Green" ),
CurrentItem = "Sublet GP %", IF ( [Sublet_GPPerc_Var] <= 0.00, "Red", "Green" ),
CurrentItem = "Liquid %", IF ( [Paint Liquid Perc Var to Budget] <= 0.00, "Green", "Red" ),
CurrentItem = "Consumables %", IF ( [Paint_Panel_ConsumablesPerc_Var] >= 0.00, "Red", "Green" ),
CurrentItem = "Overheads %", IF ( [OPS_ExpensesPerc_Var] <= 0.00, "Green", "Red" ),
CurrentItem = "Office Wages %", IF ( [Office Wages RatioPerc Var to Bud] <= 0.00, "Green", "Red" ),
CurrentItem = "Total GP %", IF ( [OPS_Total_GPPerc_Var] <= 0.00, "Red", "Green" ),
CurrentItem = "EBITDA %", IF ( [OPS_EBITDAPerc_Var] <= 0.00, "Red", "Green" )
)
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi @michaelag ,
try this.
Selected_Actual_Vaues_Performance%_Colour =
VAR CurrentItem =
SELECTEDVALUE ( 'Performance % Template'[Perforamnce %] )
RETURN
SWITCH (
TRUE (),
CurrentItem = "Revenue %", IF ( [All_Income_VarPerc] <= 0.00, "Red", "Green" ),
CurrentItem = "Parts Mix %", IF ( [Parts_RatioPerc_Var] >= 0.00, "Red", "Green" ),
CurrentItem = "Panel GP %", IF ( [Panel_GP_Perc_Var] <= 0.00, "Red", "Green" ),
CurrentItem = "Parts GP %", IF ( [Parts_GPPerc Var] <= 0.00, "Red", "Green" ),
CurrentItem = "Paint GP %", IF ( [Paint_GPPerc_Var] <= 0.00, "Red", "Green" ),
CurrentItem = "Sublet GP %", IF ( [Sublet_GPPerc_Var] <= 0.00, "Red", "Green" ),
CurrentItem = "Liquid %", IF ( [Paint Liquid Perc Var to Budget] <= 0.00, "Green", "Red" ),
CurrentItem = "Consumables %", IF ( [Paint_Panel_ConsumablesPerc_Var] >= 0.00, "Red", "Green" ),
CurrentItem = "Overheads %", IF ( [OPS_ExpensesPerc_Var] <= 0.00, "Green", "Red" ),
CurrentItem = "Office Wages %", IF ( [Office Wages RatioPerc Var to Bud] <= 0.00, "Green", "Red" ),
CurrentItem = "Total GP %", IF ( [OPS_Total_GPPerc_Var] <= 0.00, "Red", "Green" ),
CurrentItem = "EBITDA %", IF ( [OPS_EBITDAPerc_Var] <= 0.00, "Red", "Green" )
)
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Thank you 🙂 Worked a treat 🙂
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |