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...

Need Help

Anonymous
2 years 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.

Anonymous

Not applicable

2 years 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
Helper II
2 years 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?

Forum Discussion

Counting based on specific value