cancel
Showing results for
Did you mean:
Highlighted
New Member

## 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 searched the community and no I couldn't find it, not saying its not there, just I didn't find it.)   Anyway, I have a data set of employee expenses, I have Slicer 1 to filter by Employee, and Slicer 2 to filter by expense type, ie (airfare, meals, hotel, office supplies, etc. ).  I want to create a visual card that will display the average as a result of the slicers, I do no how to  use "Edit Interactions" but the problem is I am not that familiar with DAX yet and I cant get any formulas to work.  Currently, slicer 1 can select multiple people, but slice 2 can only do 1 expense at a time.  Here is an example of what I am trying to accomplish.

Sample Data Set (take note the bar visual current shows Jack and John, with the values 1000, and 2600 respectively

Emp          Exp Type        Amount              Slicer 1              Slicer 2                 Card Visual (average of airfare for the people selected)

Jack           Airfare           600                   x   Jack                  Airfare                   600 (average of jack and johns airfare by occurance)

Jack           Airfare           400                        Jill

Jack           Hotel             100                   x   John

Jack           Food              20                        Mary

Jill              Airfare           300

Jill              Hotel             150

Jill              Food               30

John          Airfare            600

John          Airfare            1100

John          Airfare            500

John          Airfare            400

Mary          Food              30

Thank you!!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User V

## Re: Average on mulitple slicers

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

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog:

Power BI em Português

Highlighted
Super User V

## Re: Average on mulitple slicers

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

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog:

Power BI em Português