Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi all,
I have a measure that sums based on week numbers (week nr).
Week nr also is a filter in my dashboard, but I cant seem to not make it react with the screenshot below.
I've tried using a calculate function with ALL('Date'[Weeknr] in the screenshot, but that doesn't work.
What could be a way to make the above screenshot ignore a filter?
thanks in advance 🙂
Solved! Go to Solution.
@FPE5 In theory SUMMARIZE( ALL( 'input' )...
@FPE5 In theory SUMMARIZE( ALL( 'input' )...
Not sure why I didnt try that, but your theory works.
Thanks for the reply and solution!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 13 | |
| 8 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 29 | |
| 19 | |
| 18 | |
| 11 | |
| 10 |