Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count Distinct Orders Raised Per Month Help

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

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        Anonymous
        Not applicable
        6 years ago

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