Adding two measures

Anonymous · ‎08-23-2022

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?

Anonymous · ‎09-01-2022

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

parry2k · ‎08-23-2022

@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!

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎08-25-2022

How can I filter "different from blank" in a measure? I am using the Filter function and I was using <> " " but that is not working