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?

MahyarTF's avatar
MahyarTF
Icon for Memorable Member rankMemorable Member
4 years ago

Hi,

it is weird,

I try to create a sample data for my self and create a dax measure on it. it is work, would you please share your sample PBIX file to investigate :

 

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

    Hi Mahya

     

    Due to company policy I am unable to share files.  The model is very simple



    The only filters on the page are

     

    My key measure is 

    Avg Rating = AVERAGE('LocalZ Feedback Files'[Rating])
     
    And for the visual that I wish to ignore the Page Filter I am using this measure
    Avg Rating all months =
    CALCULATE([Avg Rating]
         ,ALL('Calendar'))
     
    But have also tried
    Avg Rating all months =
    CALCULATE([Avg Rating]
         ,ALL())
     
    Both these measures work find when added to a card visual. However I am trying to display this via a line chart , showning the months on an axis.
    The result I was expecting is 



    But I am getting this

     

     

    Works fine in a card visual but not in a line chart.

     

    RIchard