Forum Discussion
apanta
Helper I
Helper IFilters-DAX
Hi Everyone, I will try to make my query short. So, we have this table on the server which has got the details of the rooms in each facilities and has a column called 'inactive' (boolean) to let us...
CNENFRNL
Community Champion
Community ChampionI seems you can change your verbose measure to
Active rooms = COUNTROWS( FILTER( 'Table_name', NOT 'Table_name'[Inactive] ) )From your description, it's inferred that 'Table_name' table is already filtered by date filter somewhere. Above all, DAX is not Excel worksheet formula; any discussion without date model is nothing but giberrish.