The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |