Forum Discussion

jscottNRG's avatar
jscottNRG
Helper II
7 years ago
Solved

ALL() function not working as expected

Hi, I've perused the similar forum posts but I still can't get ALL() to work as I believe it should. I'm trying to create a measure that calculates an overall average of a column -- that is, an ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago
    So you said it changes when you apply your date slices, is the date field in your slicer from your main table or from a separate calendar/date table. If it's from a separate table try putting the all statement around that field/table instead
Anonymous's avatar
Anonymous
Not applicable
7 years ago
So you said it changes when you apply your date slices, is the date field in your slicer from your main table or from a separate calendar/date table. If it's from a separate table try putting the all statement around that field/table instead
  • jscottNRG's avatar
    jscottNRG
    Helper II
    7 years ago

    Thanks all for the assistance! Anonymous was on the right track and prompted me to try adding ALL() filters to the CALCULATE() function for each dimension table in my data model (including my Calendar table), like this:

     

    Overall Score Average = CALCULATE(AVERAGE(Job_info[Score]), ALL(Job_info), ALL('Calendar'), ALL(dim_1), ALL(dim_2), ALL(dim_3), ALL(dim_4), ALL(dim_5), ALL(dim_6), ALL(dim_7), ALL(dim_8), ALL(dim_9))

    Now my "Overall Score Average" doesn't change when I make slicer selections in slicers using those dimension tables.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello,

    I have a  matrix visual with 8 to 9 columns and have one page level filter(Values:1,2,4--Applied filter not in 4) and one report level filter(Applied filter sales not in US) applied to the report. Now, when ther user filter(Yes/No filter name) out of 8 to 9 columns, 3 columns values should not be effected in the matrix but when the user selects other filters, values should change. I have all the columns and filters coming from the same table.

    Can anyone help me out in getting this?

    I have tried using this

    Calculate(DISTINCTCOUNT(column),All(Yes/No)) is not giving me the correct result.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      7 years ago

      Hi,

      Assuming the title of the Yes/No column is response and the Table name is Data, try this

      =Calculate(DISTINCTCOUNT(column),All(Data[Response]))

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hello,

         

        Thank you for your response, I just mentioned Yes/No for understanding. I did use the column name it is not working as expected when I have one more filter from the same table. Could you please help me out?