Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
This is brilliant, thank you so much.
Kind regards,
Paul
You're welcome! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |