Forum Discussion

aignn's avatar
aignn
Helper II
6 years ago
Solved

How calculate average column values with two slicer? (example inside)

Hello! How calculate average column values with two slicer?

I now have what is presented in test1.pbix

text1.pbix - https://yadi.sk/d/Z7jMzBGGqUy8iA

I have table,measure and two slicers.

Slicer "Month,year" has influence on the measure.

But slicer Queue don`t work(

I want the slice Queue to work. And it should be multiselect (like in test1.pbix)

 

Can you help me?

Thank you advance.

 

  • aignn your measure should be just simple average

     

    Measure = Average ( 'Table'[Minutes] )

     

2 Replies

  • aignn your measure should be just simple average

     

    Measure = Average ( 'Table'[Minutes] )