filter with measure

[Anonymous]

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.

[v-frfei-msft · Accepted solution]

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

[v-frfei-msft · Accepted solution]

Hi @Ronald123,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank

[v-frfei-msft]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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.

[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

[Anonymous]

https://www.dropbox.com/s/ehhoywxyhw1sv8a/MSTools_Reach_Frequency_RC_t5.pbix?dl=0

I thank you in advance

[Ronald123]

Hello @Anonymous,

Try this measure;

Cobertura: = CALCULATE(
                 SUM(DatosRF[Cobertura]);
                 DatosRF[Frecuencia]=2)

[Anonymous]

The 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.

[Ronald123]

Hi @Anonymous,

You can use a slicer, put in the slicer the colum DatosRF[Frecuencia].

Greets,

Ronald

[Anonymous]

It is true, but as the value already exists and it is seen, my boss wants not to have to be manually selected.

[Ronald123]

@v-frfei-msft,

Any idea?

[v-frfei-msft · Accepted solution]

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

[v-frfei-msft · Accepted solution]

Hi @Ronald123,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank