Show zero counts

[toafk]

I want to count number of meetings. I have two slicers. The issues is, there a rooms without any bookings and the are not shown.

Below, I created the measure
Number of Bookings = countrows(Meetings) + 0

It shows all the meeting, but the slicer (service units) does not filter, so all rooms with zero value are included.

Any hint on how to make show rooms all for the selected Service Uni but still have the slicer take effect, will be greatly appreciated.

[v-lionel-msft]

Hi @toafk ,

In other words, you want to display null values in the table visual, but also want the table visual to be controlled by the slicer(service units) ?

Please provide a sample .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@toafk , Try like

0 between range
Measure = var _1= countrows(Meetings) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))