rocio

[rcister]

Ey guys! how are you?

I need your help, I have this mesuare:

FILTER RoomN =

SWITCH(TRUE(),

SELECTEDVALUE('Filter 2'[Colum1]) = "Budget", [Budget RoomNights],

SELECTEDVALUE('Filter 2'[Colum1]) = "Forecast", [Forescast RoomNigths],

SELECTEDVALUE('Filter 2'[Colum1]) = "STLY", [STLY RoomNigths]

)

I need to be able to chose more the one choice.
E.G:  I need to be able choose budget and STLY or STLY and forecast or any other option.
Can you help me? Best Regards

[amitchandak · Accepted solution]

@rcister , if more than one is selected then you want to add values?

Try like

FILTER RoomN =

if(countx(filter('Filter 2','Filter 2'[Colum1] = "Budget"),'Filter 2'[Colum1])>0, [Budget RoomNights],blank())+
if(countx(filter('Filter 2','Filter 2'[Colum1] = "Forecast"),'Filter 2'[Colum1])>0, [Forescast RoomNigths],blank())+
if(countx(filter('Filter 2','Filter 2'[Colum1] = "STLY"),'Filter 2'[Colum1])>0, [STLY RoomNigths],blank())

or explore Calculation groups
https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallprodu...

[rcister]

this part it said mistake
>0, [Budget RoomNights],blank())+

>0, [Forescast RoomNigths],blank())+

>0, [STLY RoomNigths],blank())