Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I want a meassure with accumulated totals to be affected by a Slicer.
Solved! Go to Solution.
Hi @Anonymous
The best solution for you is to add a date table to your model and set your date filter by using that table, BTW, try this:
Titles_released_acumulated_total =
VAR _Genre =
SELECTEDVALUE ( game_info[Genre] )
RETURN
CALCULATE (
COUNT ( game_info[Genre] ),
FILTER (
ALL ( game_info ),
game_info[Date2] <= MAX ( game_info[Date2] )
&& game_info[Genre] = _Genre
)
)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @Anonymous
The best solution for you is to add a date table to your model and set your date filter by using that table, BTW, try this:
Titles_released_acumulated_total =
VAR _Genre =
SELECTEDVALUE ( game_info[Genre] )
RETURN
CALCULATE (
COUNT ( game_info[Genre] ),
FILTER (
ALL ( game_info ),
game_info[Date2] <= MAX ( game_info[Date2] )
&& game_info[Genre] = _Genre
)
)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Thank you so much. You saved me. The code works perfectly. I have a calendar table so I will try to adjust your code for that.
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
189 | |
96 | |
67 | |
63 | |
53 |