measures into matrix

Hi eduardosilvin3 ,

1. Based on your description, I created two measures.

Measure =
SUM(financials[Sales])

Measure 2 =
SUM(financials[COGS])

2. Create measures to show different results.

Measure 3 =
SWITCH(TRUE(),
MAX('financials'[Country]) = "Canada",'financials'[Measure],
MAX('financials'[Country]) = "France",'financials'[Measure 2])

So you could try changing your expression to:

TotalIndCostNoFilters Conditional =
SWITCH(
TRUE(),
SELECTEDVALUE('Concept'[type]) = "1) Whites", [TotalIndCostNoFilters A],
SELECTEDVALUE('Concept'[type]) = "2) Browns", [TotalIndCostNoFilters B],
BLANK()
)

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.