How do I ignore the column dimension in my expression?

[brandon_d]

I am trying to pull together a table of averages across different hours of the day. However, I am having a problem with getting the denominator to calculate properly. In the attached example, I would want the denominator for each of these boxes to be 30 because that is how many days of business we had during the selected time period. 

The current formula to get the values shown in the attached image is as follows:

Count(distinct([Appt Date]))

Unfortunately, this is only counting if there is an appointment date for the given time in the table. 

[Stoyan_Terziev · Accepted solution]

Hi Brandon,

Can you try this:

Count(TOTAL distinct([Appt Date]))

 It depends a bit on your model and chart structure if this will work or not. Worst case we need to go for an aggr() but let's see if the above will do the trick.

Please let me know if that helps!

Kind regards,

S.T.