Forum Discussion
filter with measure
Good afternoon, I have the result of a measurement, which I need to use as a "filter" of a table. That is, I need to see in a table only the rows in which the value of column "A" matches the result of the measurement.
Hi Ronald123,
To create a measure as below and filter the measure in the visual.
Measure = IF(MAX(DatosRF[Frecuencia])=[V_Rango_Frecuencia_redondeado],1,0)
Please check the pbix as attached.
Regards,
Frank
Hi Ronald123,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
12 Replies
v-frfei-msftCommunity Support
Hi Anonymous,
I made one sample for your reference. If it doesn't meet your requirement, kindly share your sample data and excepted result to me.
1. Create two measures as below.
Measure = CALCULATE(MAX(Table2[A]),ALL(Table2))
Measure 2 = IF( [Measure]=MAX([value]),1,0)
2. Create a table visual and filter it by Measure 2.
For more details, please check the pbix as attached.
Regards,
Frank
Sorry for not giving more information regarding my question. The measure that I use is the following V_Rango_Frecuencia_redondeado = ROUND( [V_Rango_Frecuencia];0) This measure gives me a value called FRECUENCIA, that I need to use in a table where one of its columns contains this value. The table is GRPs Frecuencia Cobertura 0 1 0 100 1 56,5 200 1 72,7 300 1 79,8 400 1 83,7 500 1 86,2 600 1 87,9 700 1 89,1 800 1 90,1 900 1 90,8 1.000 1 91,3 1.100 1 91,8 1.200 1 92,2 1.300 1 92,6 1.400 1 92,8 1.500 1 93,1 1.600 1 93,3 1.700 1 93,5 1.800 1 93,7 1.900 1 93,8 2.000 1 94 0 2 0 100 2 25,8 200 2 50,1 300 2 63 400 2 70,6 500 2 75,5 600 2 78,9 700 2 81,4 800 2 83,3 900 2 84,8 1.000 2 86 1.100 2 86,9 1.200 2 87,7 1.300 2 88,4 1.400 2 89 1.500 2 89,5 1.600 2 89,9 1.700 2 90,3 1.800 2 90,7 1.900 2 91 2.000 2 91,3 If the value obtenied in a measure is 2, the table should show me only this 0 2 0 100 2 25,8 200 2 50,1 300 2 63 400 2 70,6 500 2 75,5 600 2 78,9 700 2 81,4 800 2 83,3 900 2 84,8 1.000 2 86 1.100 2 86,9 1.200 2 87,7 1.300 2 88,4 1.400 2 89 1.500 2 89,5 1.600 2 89,9 1.700 2 90,3 1.800 2 90,7 1.900 2 91 2.000 2 91,3
- v-frfei-msft
Hi Anonymous,
Could you please share your pbix to me? You can upload the pbix to dropbox and share the link here.
Regards,
Frank