Forum Discussion

Devildogtevor's avatar
Devildogtevor
New Member
7 years ago
Solved

Average on mulitple slicers

Hello All, complete noob here, just about halfway through the first level of guided learning.  I feel hands on playing around is just as useful as formal instruction.  Here is my question, (yes i sea...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Devildogtevor,

     

    Looing at your question you don't need to had any DAX to your calculations you just need to select the Amount to the card visual and then select the Average as the summarization.

     

    However if you want to do it by a measure just add the following measure to your data:

    AVERAGE EXPENSE = AVERAGE (Table[Expense])

    The calculations are based on context given by the slicers so one of the two methods will give you the 600.

     

    Regards,

    MFelix

     

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago

Hi Devildogtevor,

 

Looing at your question you don't need to had any DAX to your calculations you just need to select the Amount to the card visual and then select the Average as the summarization.

 

However if you want to do it by a measure just add the following measure to your data:

AVERAGE EXPENSE = AVERAGE (Table[Expense])

The calculations are based on context given by the slicers so one of the two methods will give you the 600.

 

Regards,

MFelix