Changing an aggregate on a column depending on a filter

[mikelee1701]

Hi,

My data table is something like this:

Date	type	value
8-3-2022	average	10
8-5-2022	sum	4
8-6-2022	average	6
8-7-2022	sum	4

I have a slicer on type where you can choose between average and sum

in my visual, when I filter by average I'd like my visual to show 8

when I filter by sum, i'd like my visual to show 8

but what I can't figure out is, in the visuals, I am limited by only choosing one aggregate.   Can I get around this?

Thanks in advance.

Mike

[mikelee1701 · Accepted solution]

I guess it helps to take a break and come back:

I figured out how to do it.

I created a measure:

Mod-Value = SWITCH(max(table[type]),
"average", AVERAGE(AvailResp[Value]),
"sum", SUM(AvailResp[Value])
)

PS. Looking back at my question, I poorly choose my numbers where the end result is the same answer; which may cause confusion.

I should have choose numbers such sum of 50 and 50, is 100

and average of 10 and 6, is 8

regardless, I figured it out, and it appears to be working., thanks for reading.

[ryan_mayu]

@mikelee1701 

should average be 16 or 13?

pls check the attachment to see if this is what you want.

[mikelee1701]

Average should be 8.   (10+6 = 16, 16/2=8)