Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Use Slicer as a summarizer with Average values

Hi!

I have a graph that has average values in it. These average values I have calculated in a measure. In a slicer I can specify which products I want to see the average values of. But if I use more than one product, it calculates the average value of those 2. But the slicer needs to summarize these values together.


For example:

Product:Average value:
Cheese10
Milk10
Eggs10

 

What happends in my case is that the average value will stay 10. But I want that it goes to 30. How can I do this?

Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    What you need to do is an aggregator measure in this case use the SUMX:

     

    AVERAGE VALUE = IF(HASONEVALUE(Table[Product]); [AVERAGE MEASURE]; SUMX(ALLSELECTED(Table[Products]);[AVERAGE MEASURE])

     

    This will make the sum of all averages values when you don't have a single product selected.

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    You can refer to this measure and modify your own measure.

    Measure = CALCULATE(SUM('Table'[Value]),ALLSELECTED('Table'))/COUNT('Table'[Product])

     Result would be shown as below:

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi

    the average of your value for Cheese is 10, for Milk is 10 and for Eggs is 10.
    If you select only "Cheese", then the table will show only Cheese with an average that won't change as it stays at 10.

     

    So I don't understand what you want exactly. Unless you want to show 30 in the total row...?

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous ,

     

    What you need to do is an aggregator measure in this case use the SUMX:

     

    AVERAGE VALUE = IF(HASONEVALUE(Table[Product]); [AVERAGE MEASURE]; SUMX(ALLSELECTED(Table[Products]);[AVERAGE MEASURE])

     

    This will make the sum of all averages values when you don't have a single product selected.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      MFelix 

      Is it also possible with this measure that you don't select all product? For example 3, and show for these 3 the average sum value? 

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        6 years ago

        Hi Anonymous ,

         

        This works for any selection of the products doesn't matter how many you choose.

         

        If you select only one it will make the average otherwise will pick up the number of products you select and their respective averages and sum them.