Creating average of a measure in a table visualization

[sbharti123]

I have created a measure which is calculated based on selection in a slicer. Its logic is as below:

measure1 = SWITCH( SELECTEDVALUE ('QList'[QNO]), "Q1",Sum(table[Q1]),  "Q2",Sum(table[Q2]), BLANK() )

It is displaying perfectly as shown below:

NAME	MEASURE1
JOHN	100
TINA	200
MIKE	300

Now, I want to create another measure which will calculate average of all values shown in above table. That is (100+200+300) /3 = 200

Therefore, for each of the employee above, there will be a new column called MEASURE2 just showing 200.

The problem is that I have another slicer on the page which selects their manager. So for some managers there can be more/less employees.

I just can't get my head around this, can anyone suggest?

[v-frfei-msft · Accepted solution]

Hi @sbharti123 ,

To create a measure as below to get the average.

Measure = AVERAGEX(ALLSELECTED('table'),[measure1])