How to remove date filters from a measure (to use on a chart)

[campelliann]

Hi,

So I have a measure for calculating our revenue till this day which is something like, CALCULATE( sum Table1 [Revenue], Calendar[Date]<Today, Calendar[contractyear]=5).

This gives me the aggregate revenue, but can I use this measure in a chart with the months on the axis? Because this way with calculate, it will ignore the month in the axis. I was thinking if Keepfilters could help, but not sure how to use in this situation.

So basically I would like to place this measure on a chart to know the revenue on january, february etc.

Thanks

[parry2k]

@campelliann yes that would have worked too. Good, you have a solution in place, that's all matters 😀

[parry2k · Accepted solution]

@campelliann you are on right track:

CALCULATE( sum Table1 [Revenue], KEEPFILTERS ( Calendar[Date]<Today), Calendar[contractyear]=5).

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[campelliann]

:D. Many thanks again! Best wishes

[campelliann]

Thanks, i managed to make it work with values also