Forum Discussion
Solved
Same Filters - Different Behaviour
Hi guys, I built the following DAX measure, which gives the total revenue for the current year, irrespective of filters applied: TotalRevCurrentYear = CALCULATE(SUM(Revenue[Revenue]), FILTE...
Guys - I had allocated the wrong measure to the Card!
It's now working as expected thanks for your time.
In my defence - I'm about 3 hours into this and have a few measures starting "TotalRevenue*"
Hi,
Just select the current year in the slicer and these 2 measures should work
Rev = sum(Revenue[Revenue])
Units = sum(Revenue[Units_sold])
Hope this helps.