Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all,
I know this is simple, I have a sales value that has to be filtered only when there is a filter applied to Region attributes.
And any other filters applied should not get changed, I cannot use the Edit interaction because I need the value for the corresponding calculations.
Regards,
Ranjan
Solved! Go to Solution.
Hi @RanjanThammaiah ,
Have you tried it with using the ISFILTERED function?
ISFILTERED function (DAX) - DAX | Microsoft Learn
It could be something like:
IF ( ISFILTERED ('Region'), [SalesMeasure], CALCULATE ( [SalesMeasure], ALL ( 'Region' ) )
Does this work? Let me know 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
try this measure for your sales,
Sales for region =
CALCULATE(
SUM(financials[ Sales]),
ALLEXCEPT(financials,financials[Country]))
Thanks,
Arul
try this measure for your sales,
Sales for region =
CALCULATE(
SUM(financials[ Sales]),
ALLEXCEPT(financials,financials[Country]))
Thanks,
Arul
Hi @RanjanThammaiah ,
Have you tried it with using the ISFILTERED function?
ISFILTERED function (DAX) - DAX | Microsoft Learn
It could be something like:
IF ( ISFILTERED ('Region'), [SalesMeasure], CALCULATE ( [SalesMeasure], ALL ( 'Region' ) )
Does this work? Let me know 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
91 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
70 | |
67 |