Slicer para elegir 2 columnas de una tabla

[cvalarcon]

Hola ,

Tengo una tabla donde tengo dos columnas una aplicada un filtro (Fltr1) y otra con otro  filtro (Fltr2).
Tengo muchas medidas hechas con el filtro Fltr1 pero necesito q esas misma medida tambien pueda leer la columna con el Fltr2 para obtener gráficos distintos .

Me podrian ayudar para ver la manera optima de hacerlo ? 

La idea q pueda elegir entre ambas columnas cambiando las medidas y los gráficos

Gracias

[lbendlin]

Are you trying to implement an "OR"  filter between these two columns?

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[cvalarcon]

Hi ,

First of all  !!!! Happy new year !!!!!

I have a phiscal table with 2 columns with diff filters in each one.

This filters has a range of numbers as show in the formula

Column 1 

SWITCH(
    TRUE(),
    vTablaReconciliacion[Valor]=1000000000000,"Violet",
    vTablaReconciliacion[Valor]< 1.4 ,"wGreen",
    vTablaReconciliacion[Valor]>=1.7 && vTablaReconciliacion[Valor]<5,"Yellow",
    vTablaReconciliacion[Valor]>=1.7 && vTablaReconciliacion[Valor]>=5,"Red")

Column 2

Rangos Filtros (1.1 - 3) = 
SWITCH(
    TRUE(),
    vTablaReconciliacion[Valor]=1000000000000,"Violet",
    vTablaReconciliacion[Valor]<1.1,"Green",
    vTablaReconciliacion[Valor]>=1.1 && vTablaReconciliacion[Valor]<3,"Yellow",
    vTablaReconciliacion[Valor]>=3,"Red")

In the Dash I have a some measures that count the numbers of "Green", "Red" etc... as you can see in the picture- "N° Instrumentos" 

But now I need to have the possibility to choose between filter1 or 2 in order to change this range.

So I was thinking to do this in 2 options.:

opt 1.
How can a choose column 1 or 2 without replicate all calculation from column 1 or 2, (Easy way)

Opt 2. 
I started using parameters (Numeric Range) where I can call min and max and add it to the measure but I can't do it in the physical table since if I place the VALUE field (from min or max parameter) it only place the default value and not what is modified from the slicers. 
Max Parameter formula, 10 as default value

Fltr Maximo Value = SELECTEDVALUE('Fltr Maximo'[Fltr Maximo], 10)

If I place this field in a phiscal table only show the Defualt value

But if I use a virtual table I can see the values changes from the slicer, but I can not reference all measure to this kind of table or I´m wrong ???

I hope I was clear.

Thanks

[lbendlin]

Note that SWITCH is syntax sugar for nested IFs and you do not need to specify ranges multiple times.

I need to have the possibility to choose between filter1 or 2 

That's what my previous question was about.  PowerBI does not support OR filters across fields.  You need to use a measure for that.