Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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.

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Ronald123,

     

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


    Regards,
    Frank

  • Anonymous's avatar
    Anonymous
    7 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.

12 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago
      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's avatar
        v-frfei-msft
        Community Support
        7 years ago

        Hi Anonymous,

         

        Could you please share your pbix to me? You can upload the pbix to dropbox and share the link here.

         

        Regards,

        Frank