Filter score card according to the parameter from the filter

[Anonymous]

Hi all,

I need help for really easy situation.

I have a score card. I want to create if case it works with a value which come from filter. The filter should has just 2 parameter. Like "1" and "2". I want to make  2 different calculation in if case.

I want to create a calculation like that
if a selected value from filter is 1 then
= AppendTable2[ValueDiv]
if a selected value from filter is 2 then
= AppendTable2[ValueMor]

I couldn't find how can i create a filter like that. 

[v-yuezhe-msft · Accepted solution]

@Anonymous,

I make a test in the following sample data.


I add a new parameter as below, and create a measure in appendtable2.

Measure = var selected=SELECTEDVALUE(Parameter[Parameter]) return IF(selected=1,SUM(AppendTable2[ValueDiv]),SUM(AppendTable2[ValueMor]))

If the above dax don't help, please share sample data of your table here.

Regards,
Lydia