Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Solved! Go to 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 , 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...
this part it said mistake
>0, [Budget RoomNights],blank())+
>0, [Forescast RoomNigths],blank())+
>0, [STLY RoomNigths],blank())
User | Count |
---|---|
84 | |
69 | |
69 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |