sum of average with slider

[Anonymous]

Hello everyone, i haven't been able to come up with the right DAX for a measure that helps me with following: i have a set of data that looks like:

Date	Location	Quantity
01-Mar-22	C1	10
02-Mar-22	C1	12
01-Mar-22	C2	14
02-Mar-22	C2	20

and i would like to have a dashboard with 2 sliders (date, location) and a card that shows the sum of the average quantity like this:

this is that when the slider selects multiple dates (Q1 in the example) and one location then it shows the average quantity in that location, when the slider selects multiple dates (Q1 in the example) and multiple locations  (C1 and C2) then the card shows the sum of the average quantity by location. 

any help is highly appreciated!

Thanks,

Edison 

[tamerj1 · Accepted solution]

Hi @Anonymous 

you may try

Sum of Average =
SUMX ( SUMMARIZE ( Table, Table[Locatin], Table[Date] ), [Average] )

[amitchandak]

@Anonymous , Nor very clear, But interactions can help

How Interactions Work- Split Page using interactions to compare: https://youtu.be/GIfRKzhMaR4