Forum Discussion

eduardosilvin3's avatar
eduardosilvin3
Helper II
2 years ago
Solved

measures into matrix

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

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
    eduardosilvin3
    Helper II
    2 years ago

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