Forum Discussion

datapal04's avatar
datapal04
Icon for Helper I rankHelper I
3 years ago
Solved

Evaluate for Every Row

Hello,    I have data as per the below table. I also have a matrix visual for the data per the snippet below.   I have a measure for conditional formatting the background colours (current code be...
Need Help
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    3 years ago

    Instead of CALCULATE you can do a simple &&

    KPI Cond. Formatting Color = 
SWITCH (
    TRUE (),
    SUM ( 'CSD KPIs Data'[KPI Value] ) >= SUM ( 'CSD KPIs Data'[Target] ) 
    && 'CSD KPIs'[Favourable Trend] = "H"
    , "#73b761",
    SUM ( 'CSD KPIs Data'[KPI Value] ) < SUM ( 'CSD KPIs Data'[Target] )
    && 'CSD KPIs'[Favourable Trend] = "H"
    , "#fd625e",
    SUM ( 'CSD KPIs Data'[KPI Value] ) > SUM ( 'CSD KPIs Data'[Target] )
    && 'CSD KPIs'[Favourable Trend] = "L"
    , "#fd625e",
    SUM ( 'CSD KPIs Data'[KPI Value] ) <= SUM ( 'CSD KPIs Data'[Target] )
    && 'CSD KPIs'[Favourable Trend] = "L"
    , "#73b761"
)

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Instead of CALCULATE you can do a simple &&

KPI Cond. Formatting Color = 
SWITCH (
    TRUE (),
    SUM ( 'CSD KPIs Data'[KPI Value] ) >= SUM ( 'CSD KPIs Data'[Target] ) 
    && 'CSD KPIs'[Favourable Trend] = "H"
    , "#73b761",
    SUM ( 'CSD KPIs Data'[KPI Value] ) < SUM ( 'CSD KPIs Data'[Target] )
    && 'CSD KPIs'[Favourable Trend] = "H"
    , "#fd625e",
    SUM ( 'CSD KPIs Data'[KPI Value] ) > SUM ( 'CSD KPIs Data'[Target] )
    && 'CSD KPIs'[Favourable Trend] = "L"
    , "#fd625e",
    SUM ( 'CSD KPIs Data'[KPI Value] ) <= SUM ( 'CSD KPIs Data'[Target] )
    && 'CSD KPIs'[Favourable Trend] = "L"
    , "#73b761"
)