Forum Discussion
Adding two measures
I have a report with two tabs, each tab has two measures that I want to add. Each measure is filtered according to different criteria; the filters are on the visual, not on the formula itself; thererefore, when I add the measures I get a big number which is the result of adding my measures as if they did not contain a filter. How can I solve this?
3 Replies
Anonymous write another measure which the filter in the measure expression and then sum these up
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
Hi Anonymous,
It seems like the filter does not correspond apply to the measures. Have you checked to confirm the filter interaction with your formula? Please share some more detailed information to help us clarify your scenario:
How to Get Your Question Answered Quickly
Notice: visual level filter only existed on the current visual, you can't get the filter effect from other visuals
Regards,
Xiaoxin Sheng
