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

     

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity 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