Counting based on specific value

[mgaut341]

I created a date difference column to look at the difference when an appt is scheduled to the appt date. I am interested in the appts that are scheduled the same day (date difference =0).

When I try to create a visual to count the date difference to be 0 it is not accurate. 

I have tried the following formulas:

# appts schd same day =

COUNTROWS(FILTER('New Appointment_Fact','New Appointment_Fact'[Scheduling Days]=0))

and 

# appts schd same day =

CALCULATE(

    COUNT('New Appointment_Fact'[Scheduling Days]),

    FILTER('New Appointment_Fact','New Appointment_Fact'[Scheduling Days]=0))

Any ideas on what I am doing incorrectly?

[v-kongfanf-msft · Accepted solution]

Hi @mgaut341 ,

You can try formula like below:

sameday = CALCULATE(COUNTROWS('Table'),'Table'[Scheduling Days] = 0)

If the problem persists, please provide relevant test data and describe it.

Best Regards,
Adamk Kong

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

[mgaut341]

yes, that did work!

However I now run into another problem

I want to know the percentage of appts scheduled the same day, but I get a circular dependency.

Do you know how to fix this?

[PijushRoy]

Hi @mgaut341 

Can you please try the below DAX?

Appts_Schd_Same_Day = 
CALCULATE(
    COUNTROWS('New Appointment_Fact'),
    FILTER(
        'New Appointment_Fact',
        'New Appointment_Fact'[Scheduling Days] = 0
    )
)

 Please let me know if not works 

[mgaut341]

Unfortunately, it still doesn't work