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.
I have a measure named Total Turnover which calculates the sum of Turnover as per the filters applied.
Total Turnover =
Hi @Anonymous ,
You can keep the filter you want by ALLEXCEPT() or remove filters by REMOVERFILTER() which you do not want to keep. Or All() to fix the result.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Take a look at this link and hopefully you'll be able to identify the cause: https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/
All the best.
Theo 🙂
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
User | Count |
---|---|
77 | |
76 | |
36 | |
31 | |
29 |
User | Count |
---|---|
93 | |
79 | |
57 | |
48 | |
48 |