DAX for Count Using A specific Date

[ERing]

I need to get a count of Jobs Scheduled using the table FACT_JOBS using JOB_BOOKING_SOURCE and JOB_CREATEDON.

I'm having trouble because the FACT_JOBS is connected to DIM_CALENDAR on DATE and the DATE for each record in FACT_JOBS may be different from the JOB_CREATEDON date.

I'm also usin DIM_CALENDAR.DATE to drive a date slicer on my visuals. 

My challenge is that I want to get a count of JOBS where JOB_BOOKING_SOURCE = "Online" AND where JOB_CREATEDON dates are between the dates in my slicer.

So my expectation is measure that returns a count of JOBS where JOB_BOOKING_SOURCE = ONLINE AND JOB_CREATEDON dates is between the dates in my date slicer.

[v-echaithra]

Hi @ERing ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,

Chaithra E.

[v-echaithra]

Hi @ERing ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided resolved your issue? or let us know if you need any further assistance.
If my response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,
Chaithra E.

[v-achippa]

Hi @ERing,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Ashish_Mathur  for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[Ashish_Mathur · Accepted solution]

Hi,

This simple measure should work

Measure = calculate(countrows(Fact_jobs),Fact_jobs[JOB_BOOKING_SOURCE]="online")

Ensure that the date slicer is built from the Calendar table.

Hope this helps.