Forum Discussion

mgaut341's avatar
mgaut341
Helper II
1 year ago
Solved

Counting based on specific value

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?
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

4 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    1 year ago

    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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
      mgaut341
      Helper II
      1 year ago

      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?