topic Re: measures into matrix in DAX Commands and Tips

measures into matrix

eduardosilvin3 — Wed, 12 Jun 2024 16:40:41 GMT

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

Re: measures into matrix

eduardosilvin3 — Wed, 12 Jun 2024 16:54:18 GMT

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

Re: measures into matrix

Anonymous — Thu, 13 Jun 2024 01:44:12 GMT

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.