Forum Discussion

cottrera's avatar
cottrera
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

DAX ALL not working

Hi   I have a simple model with a facts table and dates table.  My report page has 5 visuals and the page has a filter on it for the current month = true. For one of my visuals with displays a scor...
Need Help
  • NickolajJessen's avatar
    NickolajJessen
    4 years ago

    I'm guessing it's due to the fact that you you have a measure instead of a column to decide CurrentMonth. 
    Did you consider using a calculated column on the calendar table or using visual level filters on 4 of the visuals and not using the filter on the 5th visual?

NickolajJessen's avatar
NickolajJessen
Icon for Solution Sage rankSolution Sage
4 years ago

I'm guessing it's due to the fact that you you have a measure instead of a column to decide CurrentMonth. 
Did you consider using a calculated column on the calendar table or using visual level filters on 4 of the visuals and not using the filter on the 5th visual?

  • cottrera's avatar
    cottrera
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    Hi NckolajJessen 

     

    My CurrentMonth is a ciolumn i the dates table. I already have it set up with 4 of the visuals set as 'True' and the remainding one not using the filter.
    I wanted to explore if there was a way to avoid adding 4 addtional filters to visuals as I am trying the keep the performace of the report good.

     

    Regards

     

    Richard