Count Distinct Orders Raised Per Month Help

[Anonymous]

Hi,

I am new to Power BI so would really apprechiate some help with this question as it will help me progress my dashboard.

I have a table called JOBS that has 3 fields im interested in JOB NUMBER, JOB_RAISED_DATE and SK_JOB_RAISED_DATE.

I am wanting to create a measure to Count how many distinct/unique JOB_NUMBERs have been raised within a MONTH.

I have an active relationship between my JOBS table and a CALENDAR table. The active relationship is CALENDER[DateAsInterger] and JOBS[SK_JOB_RAISED_DATE]. The relationship is 1 to Many.

Any help would be apprechiated as once i can solve this i can apply the same measure to calculate other montly measures

Thanks

[Anonymous]

Hi @Anonymous,

Assuming there is nothing odd with your data here, like duplicate Job Numbers, your measure should be reasonably straignt forward:

JobCount = COUNTX(Jobs, Jobs[Job_Number])

You can then use this alongside your Calendar[Date] field to summarise by Year/Quarter/Month/Day.

Cheers,

Andy

[Anonymous]

Thanks @Anonymous that makes sense now and works as i expected it.

You many see some more help requests if the future as i familiarise myself with Power BI

Thanks again

[Anonymous · Accepted solution]

No Problem @Anonymous. Glad I could help.

Please mark my reply as a solution to help others members of the community find answers that work. 😊