Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
93 | |
85 | |
77 | |
68 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |