IF Statement List based on measure results

[paulvans182]

Good afternoon,

I have the following calculation

Match Up Count Rows = CALCULATE(COUNTROWS('Game Fact'),FILTER('Game Fact','Game Fact'[Game Board]IN ALLSELECTED('Game Fact'[Game Board])))

If I place that measure in a table with Game ID, I get the following:

 

Is there a way that I can store the Game IDs where the Result is equal to 22 into a variable?  I would then like to be able to use that variable as part of a FILTER component for further CALCULATE expressions?

Kind regards,

Paul

[AntrikshSharma · Accepted solution]

You could use something like this, also you can replace the whole FILTER with KEEPFILTERS and ALLSELECTED.

Match Up Count Rows =
VAR Something =
    FILTER (
        VALUES ( GameID ),
        CALCULATE (
            COUNTROWS ( 'Game Fact' ),
            KEEPFILTERS ( ALLSELECTED ( 'Game Fact'[Game Board] ) )
        ) = 22
    )
RETURN
    Something

[paulvans182]

This is brilliant, thank you so much.

Kind regards,

Paul

[AntrikshSharma]

You're welcome! 🙂