use measure as an argument for the function filter

Question

Is it possible to use a measure as the condition for the filter function? For example Medida = filter('Actividad_Campaña';[Frec_T]=[Medida1])

liviolanzo · Answer

Anonymous&nbsp;it is possible

liviolanzo · Answer

Hi AnonymousI am sorry but I can't provide any formula if you do not show us an example

anonymous · Answer

could you tell me how? because I tried it and does not recognize the argument

anonymous · Answer

The key to changing the filter context is CALCULATE.&nbsp; See if this example helps:&nbsp;1) Create your Measure you want to use:Total Sales = SUM ( Sales[Unit Price] )2) Create a second measure that will use the base measure as a filter argument:Total Sales Filter = 
CALCULATE( 
	COUNTROWS(Customer), 
		Filter( 
			Sales,
			[Total Sales] &gt;100
		)
)
		This will give us the # of customers that have total sales &gt; 100.&nbsp; So just a quick example of how to use measures in filter arguments.&nbsp;&nbsp;

anonymous · Answer

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 this0	     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&nbsp;

Forum Discussion

use measure as an argument for the function filter

5 Replies

Related content

Table.Sort, unexplainable behaviour with a two-argument function

Send Argument

Custom function Expression Error: 1 argument passsed which expects 2 arguments.

Argument '3' in if function is required

Argument '2' in CALCULATE function is required.