Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a measure named Total Turnover which calculates the sum of Turnover as per the filters applied.
Total Turnover =
Hi @DAXSouvik ,
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 @DAXSouvik
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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |