Forum Discussion
Re-occurring filter issue after publishing
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.
Community SupportHi 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.
- v-yanjiang-msft
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