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...
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.

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.