Forum Discussion

Frequent Visitor

5 years ago

Solved

rocio

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])...

Need Help

amitchandak
5 years ago
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=asallproducts-allversions#limitations

amitchandak

Super User

5 years ago

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=asallproducts-allversions#limitations

rcister

Frequent Visitor

5 years ago

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

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

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