Scenarios on FactTable

Hi Manuel123 ,

So you want two measures based on the selected scenrio in slicer?

measure1 is Scenario1 with sum(Fact).

 -- always return sum(Fact) of Scenario1?

measure2 is Scenario2 with calculate(sum(Fact),all(Facttable),Filter(Facttable, Scenario = selectedvalue(DistinctScenarioTable))).

--return sum(Fact) of selected scenario in slicer?

If I understand you correctly, you could refer below formulas.

measure 1 = calculate(sum('table'[fact]),filter(allselected('table'),'table'[scenario] = "scenario1"))

measure 2 = calculate(sum('table'[fact]),filter(allselected('table'),'table'[scenario] = selectedvalue('slcier'[scenario])))
Please correct me if I misunderstood your meaning.

Best Regards,

Jay