Forum Discussion
filter with measure
- 7 years ago
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
- 7 years ago
Hi Ronald123,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank - Anonymous7 years ago
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.
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
Hi Anonymous,
Could you please share your pbix to me? You can upload the pbix to dropbox and share the link here.
Regards,
Frank
- Anonymous7 years agoNot applicable
https://www.dropbox.com/s/ehhoywxyhw1sv8a/MSTools_Reach_Frequency_RC_t5.pbix?dl=0
I thank you in advance
- Ronald1237 years ago
Resolver III
Hello Anonymous,
Try this measure;
Cobertura: = CALCULATE(
SUM(DatosRF[Cobertura]);
DatosRF[Frecuencia]=2)- Anonymous7 years agoNot applicableThe problem is that it is not a fixed number (it's not always 2). The result of the measure can be any value, it is variable.