Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
A few hours or days after publishing the filters which I have writtin into the DAX measure on my visuals stop working. For example:
Solved! Go to Solution.
Hi,
Thank you for the response, my solution ended up being to add a calculated column to the MI_Data table which returns a numeric value based on the [Ebit?] column and filter the measure based on the calculated column instead.
Hi @LiamPriestmanHH ,
Try to add ALL function in the filter like this:
Cost Avoidance Spend =
SWITCH (
SELECTEDVALUE ( 'Current'[Currency] ),
"USD",
SUMX (
FILTER ( ALL ( MI_Data ), MI_Data[Ebit?] = "Non-Ebit" ),
MI_Data[Invoice USD]
),
"Euro",
SUMX (
FILTER ( ALL ( MI_Data ), MI_Data[Ebit?] = "Non-Ebit" ),
MI_Data[Invoice (EUR)]
),
"Local",
SUMX (
FILTER ( ALL ( MI_Data ), MI_Data[Ebit?] = "Non-Ebit" ),
MI_Data[Invoice]
)
)
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thank you for the response, my solution ended up being to add a calculated column to the MI_Data table which returns a numeric value based on the [Ebit?] column and filter the measure based on the calculated column instead.
Hi @LiamPriestmanHH ,
Glad your problem has been solved! If you don't have other problems, would you mind accept your reply as solution? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,
Community Support Team _ kalyj
User | Count |
---|---|
77 | |
74 | |
60 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |