Return Max of Any SelectedValue in Switch?

[kylewilley]

Hello all,

I am looking to be able to return the max value of a measure based on any value of the measure that filters the switch statement. Basically, what I have is this:

GroupCount = 
VAR  _1stTable = 
CALCULATE(SUM('Table 1'[IncCount]),FILTER([filter statement]))
VAR _2ndTable = 
CALCULATE(SUM('Table 2'[IncCount]),FILTER([filter statement]))
VAR _3rdTable = 
CALCULATE(SUM('Table 3'[IncCount]),FILTER([filter statement]))

RETURN
SWITCH(
SELECTEDVALUE(RiskAnalysisMetric[Metric]),

"AAA", _1stTable,
"BBB", _2ndTable,
"CCC", _3rdTable
)

The Switch works fine, but I am trying to create a graph with a max line for all metrics. I need to be able to run each iteration of the [Metric], and return the max value from _1stTable, _2ndTable, or _3rdTable, whichever is higher.

[Ritaf1983 · Accepted solution]

Hi @kylewilley 
It seems a scenario for field parameters, using them you can show all selections.

Please check this tutorial :

https://www.youtube.com/watch?v=TufnsAxJsjs

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly