Switch statement

[Anonymous]

Hi everyone,

I have a matrix table with ColumnA, ColumnB, and ColumnC. In my measure below, you can see that I only added ColumnA. The measure should only respond to that column, but unfortunately, it shows also red or green circles for ColumnB and ColumnC. 
In which way can my measure be improved, so that the measure doesn't show anything (so it respond to this: "") anymore?  

IF(

    NOT ISBLANK( [Werkelijk YTD BJ] ),

SWITCH(

    TRUE(),

    [Werkelijk YTD BJ] > [Werkelijk YTD VJ] &&

      SELECTEDVALUE(Table[ColumnA]) = "Eigen vermogen" ||

      SELECTEDVALUE(Table[ColumnA])  = "Brutomarge"  ||

      SELECTEDVALUE(Table[ColumnA]) = "Overige bedrijfsopbrengsten"  ||

      SELECTEDVALUE(Table[ColumnA]) = "Buitengewone baten en lasten" ||

      SELECTEDVALUE(Table[ColumnA]) = "Aandeel in resultaat ondern. waarin deelgenomen"  ||

      SELECTEDVALUE(Table[ColumnA]) = "Financiële baten en lasten"  ||

      SELECTEDVALUE(Table[ColumnA]) = "Vaste activa" ||

      SELECTEDVALUE(Table[ColumnA]) = "Aandeel derden in groepsvermogen"  ||  

      SELECTEDVALUE(Table[ColumnA]) = "Egalisatierekeningen"  ||

      SELECTEDVALUE(Table[ColumnA]) = "Vlottende activa"  ||

      SELECTEDVALUE(Table[ColumnA]) = "Resultaat aandeel derden"  ||

      SELECTEDVALUE(Table[ColumnA]) = "Voorzieningen",

   "🟢🟢",

   "🔴🔴" ),

   IF( NOT ISBLANK( [Werkelijk YTD BJ] ),

SWITCH(

    TRUE(),

    [Werkelijk YTD BJ] < [Werkelijk YTD VJ] &&

 SELECTEDVALUE(Table[ColumnA]) = "Achtergestelde leningen" ||

      SELECTEDVALUE(Table[ColumnA])  = "Langlopende schulden"  ||

      SELECTEDVALUE(Table[ColumnA]) = "Kortlopende schulden"  ||

      SELECTEDVALUE(Table[ColumnA]) = "Som der bedrijfslasten" ||

      SELECTEDVALUE(Table[ColumnA]) = "Belastingen",

    "🔴",

    "🟢" ),

    ""

   )

)

[amitchandak]

@Anonymous , Try one of the two

IF(
NOT ISBLANK( [Werkelijk YTD BJ] ),
SWITCH(
TRUE(),
[Werkelijk YTD BJ] > [Werkelijk YTD VJ] &&
(
"Eigen vermogen" IN VALUES(Table[ColumnA]) ||
"Brutomarge" IN VALUES(Table[ColumnA]) ||
"Overige bedrijfsopbrengsten" IN VALUES(Table[ColumnA]) ||
"Buitengewone baten en lasten" IN VALUES(Table[ColumnA]) ||
"Aandeel in resultaat ondern. waarin deelgenomen" IN VALUES(Table[ColumnA]) ||
"Financiële baten en lasten" IN VALUES(Table[ColumnA]) ||
"Vaste activa" IN VALUES(Table[ColumnA]) ||
"Aandeel derden in groepsvermogen" IN VALUES(Table[ColumnA]) ||
"Egalisatierekeningen" IN VALUES(Table[ColumnA]) ||
"Vlottende activa" IN VALUES(Table[ColumnA]) ||
"Resultaat aandeel derden" IN VALUES(Table[ColumnA]) ||
"Voorzieningen" IN VALUES(Table[ColumnA])
),
"🟢🟢",
IF(
[Werkelijk YTD BJ] < [Werkelijk YTD VJ] &&
(
"Achtergestelde leningen" IN VALUES(Table[ColumnA]) ||
"Langlopende schulden" IN VALUES(Table[ColumnA]) ||
"Kortlopende schulden" IN VALUES(Table[ColumnA]) ||
"Som der bedrijfslasten" IN VALUES(Table[ColumnA]) ||
"Belastingen" IN VALUES(Table[ColumnA])
),
"🔴", "🟢"),
""
)
),
""
)

or

IF(
NOT ISBLANK( [Werkelijk YTD BJ] ),
SWITCH(
TRUE(),
[Werkelijk YTD BJ] > [Werkelijk YTD VJ] &&
COUNTROWS(
INTERSECT(
{"Eigen vermogen", "Brutomarge", "Overige bedrijfsopbrengsten", "Buitengewone baten en lasten", "Aandeel in resultaat ondern. waarin deelgenomen", "Financiële baten en lasten", "Vaste activa", "Aandeel derden in groepsvermogen", "Egalisatierekeningen", "Vlottende activa", "Resultaat aandeel derden", "Voorzieningen"},
VALUES(Table[ColumnA])
)
) > 0,
"🟢🟢",
IF(
[Werkelijk YTD BJ] < [Werkelijk YTD VJ] &&
COUNTROWS(
INTERSECT(
{"Achtergestelde leningen", "Langlopende schulden", "Kortlopende schulden", "Som der bedrijfslasten", "Belastingen"},
VALUES(Table[ColumnA])
)
) > 0,
"🔴🔴",
""
)
),
""
)

[Anonymous]

Hi @amitchandak ,

Thanks for your reply and suggestions! It is not working like I had in mind yet. I still get circles for columnB and C, even though that is not specified in the measure. And the colours are also not correct yet. 
I created a sample dataset, with the results as it should be in the matrix table (https://docs.google.com/spreadsheets/d/12KtdwxxwfQ7p827dC4Q9DD9ssiWYvj4C/edit?usp=sharing&ouid=11807...). 

To clarify it better: When the results are higher compared to previous year (2023 vs 2022), it can be positive. Than a green dot should be visible (and a red dot if it is lower). But it can be the case that it is about costs, and than a red dot should be visible when those costs are higher (and a green dot when the costs are lower). And for ColumnC, so when the hierarchy levels is completely expanded in the matrix table, no dots should be visible (since it is less relevant to show anything). 
I hope this explains it in more detail!