Forum Discussion
JimOnABike
1 year agoRegular Visitor
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...
- 1 year ago
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*"
danextian
1 year agoSuper User
Hi JimOnABike
Did you click on dimensions other than from the Date table? If so, that is expected as the filter modifier is applied to that table only.