measures into matrix

[eduardosilvin3]

Hi team, I am traying to combine 2 matrix.

rows 'Concept'[type]
columns 'DC'[Location_name]
values I have 2 measures with correct results,

TotalIndCostNoFilters A = [TotalIndCostNoFilters per LB]  * [TotalRevenue% W]

TotalIndCostNoFilters B = [TotalIndCostNoFilters per LB]  * [TotalRevenue% B]

So, I need that the matrix shows

Concept[type] = "1) Whites" in my "New Matrix Column" shows "TotalIndCostNoFilters A" measure result

Concept[type] = "2) Browns" in my "New Matrix Column" shows "TotalIndCostNoFilters B" measure result

Thanks in advance

[Anonymous · Accepted solution]

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.

[eduardosilvin3]

sorry, mistake in the first sentence, "Hi team, I am traying to combine 2 measures"