Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter graph base on 2 selection

Hello


I have a table with Itens, in this case is (mycat)
Please help me to find out a way to calculate my MyfiltCol base on my max 2 selections exemple below

Table:


Filter and formula 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Problem!! if i select 3 values (A , Band C ) should change to blank but is not working =(

Please can some one help me ?

Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    Try something like.

     

    Measure = 
IF(
    COUNTROWS( ALLSELECTED( 'Table'[Column1] ) ) <= 2,
    COUNTROWS( 'Table' ),
    "blank"
)

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

2 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Anonymous 

     

    Try something like.

     

    Measure = 
IF(
    COUNTROWS( ALLSELECTED( 'Table'[Column1] ) ) <= 2,
    COUNTROWS( 'Table' ),
    "blank"
)

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Tank you alot work perfect for my needs 😃  5 stars