Forum Discussion
Switch function from two seperate tables???
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())
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....
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())