Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi, I have this formula - sum([Sales]) that I am using in a chart.
is there a way to write this formula so that only one field can be used to change the data in the chart(to filter) - Month?
I want to make sure sums are always shown the same no matter what selections we have in the app, but I want to change the chart only based on Month filter.
thank you
Please try with
sum({1<Month=P(Month)>}[Sales])
maybe also helpful:
Sum({1<Month=$::Month>} Sales)