Forum Discussion
filter with measure
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,
FrankTHANKS FOR YOUR ANSWER. IT IS NOT WHAT I WAS LOOKING FOR, ALTHOUGH I BELIEVE THAT WHAT I WANTED TO DO IS NOT POSSIBLE. I THANK YOU VERY MUCH OF YOUR TIME.
Community SupportHi 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
https://www.dropbox.com/s/ehhoywxyhw1sv8a/MSTools_Reach_Frequency_RC_t5.pbix?dl=0
I thank you in advance
Ronald123Resolver III
Hello Anonymous,
Try this measure;
Cobertura: = CALCULATE(
SUM(DatosRF[Cobertura]);
DatosRF[Frecuencia]=2)
THANKS FOR YOUR ANSWER. IT IS NOT WHAT I WAS LOOKING FOR, ALTHOUGH I BELIEVE THAT WHAT I WANTED TO DO IS NOT POSSIBLE. I THANK YOU VERY MUCH OF YOUR TIME.