Forum Discussion

JimOnABike's avatar
JimOnABike
Regular Visitor
1 year ago
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...
Need Help
  • JimOnABike's avatar
    JimOnABike
    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*"  

     

shafiz_p's avatar
shafiz_p
Super User
1 year ago

Hi JimOnABike  To get exact result, it is better to provide representative data and desired output. It is not clear, what is changing actually. Since, ALL removes all filters from the specified table, but if there are other filters or slicers applied to the 'Revenue' table, they might still affect the measure. So, to include only current year, you could try this filter:

 

FILTER(
        ALL('Date'),
        'Date'[year] = YEAR(TODAY())
    )

 

 

Hope this helps!!

If this solved your problem, please accept it as a solution

 

Best Regards,
Shahariar Hafiz

  • JimOnABike's avatar
    JimOnABike
    Regular Visitor
    1 year ago

    Thanks for coming back on this. Expected behaiour (wanted) is for both card values to be unaffected by a change in filter. Here I have filtered to 2020 (the MAX year in the dataset). Revenue is 2.5bn, Units Sold is 476:

     

    Now if I change the  filter (top-left) to 2019...

    Total Number of Units has changed, but Total Revenue is unaffected.

    I do want selections made to country and product dimensions to change the card values, and they do. What I don't understand is why two measures from the same table, using the same filter() are giving different behaviour...