Card Visual with Variable to reference 1 of 27 columns based on slicer

[JanGunni]

Hey, I am trying to do the following:

I have a report page with 3 graphs and two slicers. 

- Slicer A references a time frame

- Slicer B references one of 27 units.

The graphs show one of 27 units at the given time frame. 

I want to add a card to the graph displaying the average value for the time frame and unit. 

The card value only allows one field, tried to do it with a field measure but was only semi successful since it required another slicer on the page which I want to avoid. 

Can I write a measure that is essentially a variable? I will have the measure to calculate the average in each of the 27 units. I want the variable to reference one of them based on the selection in the unit slicer. 

[JanGunni · Accepted solution]

I found a solution myself! To anyone who needs to know how this works:

- I created the average measure in each of my tables.

- I created one additional measure that sums up all of the average measures.

- That one summation measure I put into the field value for the card and it is filtered by the unit filter!