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 measureNumber 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.
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.
@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]) returnCALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))
Proud to be a Super User!
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.