Forum Discussion
rocio
FILTER RoomN =
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
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
2 Replies
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#limitationsthis part it said mistake
>0, [Budget RoomNights],blank())+>0, [Forescast RoomNigths],blank())+
>0, [STLY RoomNigths],blank())
