Switch function from two seperate tables???

[Anonymous]

Hi Experts

Is it possible to askthe swtich function to look at two seperate tables and apply the correct measures depending on what filter is selected...so i currently have..

MeasureName2 = IF(ISCROSSFILTERED(ProfitabilityMeasures[MeasureName]),SWITCH(TRUE(),
        VALUES(ProfitabilityMeasures[MeasureName]) = "Net Sales", [Net Sales @AOP BM %],
        VALUES(ProfitabilityMeasures[MeasureName]) = "Gross Margin", [Total Margin %],
 VALUES(ProfitabilityMeasures2[MeasureName2]) = "Apples", [Total Margin Net],
 VALUES(ProfitabilityMeasures2[MeasureName2]) = "banana", [Total Margin LY],
BLANK()),BLANK())   

[Baskar]

@Anonymous

Create all the measures Names  in one table (ProfitabilityMeasures[MeasureName]) 

like this 

MeasureName

Net Sales
Gross Margin
Apples
banana

and try this below measure Net SalesGross MarginApplesbanana

MeasureName2 = SWITCH(CONCATENATEX(VALUES(ProfitabilityMeasures[MeasureName]),ProfitabilityMeasures[MeasureName],","),
"Net Sales", [Net Sales @AOP BM %],
"Gross Margin", [Total Margin %],
"Apples", [Total Margin Net],
"banana", [Total Margin LY],
BLANK())

[Anonymous]

All Thanks...

But two tables is also possible???? - i understand the one table solution.

[Maddy99]

yes it can. i build 1 swicht depand on a filter like yours and on the format filter.

but i dont quite understand what you want.do you have an chart example of your result?

you have 4 measure and you want to show 1 measure as correct depands on the filter?

mvg,

madelon

[Anonymous]

Hi thanks for the feedback...

tables i has the gross margine and net sales, table 2 has the apples and banana, i have two filters... if i select say for instant apples then return back measure 3....

[Maddy99 · Accepted solution]

I try it, and it could work technical.

under here my test in picture. 

there are only a few but. the swicht goes from bottom to top. 

if the first is true. like legend is proposta2. than it does not mather if the catory is also true, it only shows the first measure. 

wich makes sens to me.

the final row in my table does no have a defined leged than i looks for the category.

gives this a idea of what you could do?

switch = 
VAR Legend = SELECTEDVALUE(Table1[Column1])
VAR Category = SELECTEDVALUE(ProductCategory[Name])
RETURN 
SWITCH(TRUE();
    Legend = "Proposta2"; [Measure 2] ;
    Legend = "Proposta3"; [Measure 3];
    Category = "Bikes"; [Measure 4];
    Category = "Clothing"; [Measure 5];
BLANK())

[Anonymous]

Hi

I cannot get this measure to work it works for the first VAR only...

ProfitabilityMeasureSwitch = 
VAR ProfitbabilityMeasure = SELECTEDVALUE(ProfitabilityMeasures[MeasureName])
VAR ReportingMeasure = SELECTEDVALUE(Reporting[Reporting])
RETURN 

SWITCH(TRUE(),
    ProfitbabilityMeasure = "Gross Margin", [Total Margin %] ,
    ProfitbabilityMeasure = "Net Sales", [Net Sales @AOP BM %],
    ReportingMeasure = "NOE", [YoY NOE Variance],
    ReportingMeasure = "Reported", [YoY Reported Variance],
BLANK())