Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

MATRIX VISUALS: DIVIDE COUNT VALUES, ANOTHER TABLE'S VALUE

Hello PowerBI Community,

I need some help dividing a "Count" (as a numerator) by pre-specified values without having the values summarized or other unnecessary calculation.(denominator) {count/hrs}

I got two tables, Case Logs and Productive Hours.

Case log shows the data of cases received per day and how many activities recorded by the case owner while working on it. See below sample data table


Productive Hours Table shows duration of work hours per day.

 

So, I created a matric getting the count distinct for number of unique cases[case number] per case owner and date and just count the activties. Resulting to this



How can I bumped in the productive hours to this matrix visuals without doing any calculation or summarized the productive hours value?
Can I create a measure if the count table is in a matrix visuals? so I can the cases per hour or activities per hour?

thank you for your help. Appreciate it.

Need Help
Tutorial Requests
  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    3 years ago

    Hi Anonymous ,

     

    According to your description, here is my suggestion.

    If the columns "Number of Cases" and "Number of Activities" are created under table "Productive Hours". you can create a measure as followings.

    Measure 3 = DIVIDE(MAX('Productive Hours'[Number of Activities]),MAX('Productive Hours'[Productive Hours]))

    Or if the columns "Number of Cases" and "Number of Activities" are created in another table, you can establish a relationship between two tables, and use RELATED function.

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Anonymous ,

     

    According to your description, here is my suggestion.

    If the columns "Number of Cases" and "Number of Activities" are created under table "Productive Hours". you can create a measure as followings.

    Measure 3 = DIVIDE(MAX('Productive Hours'[Number of Activities]),MAX('Productive Hours'[Productive Hours]))

    Or if the columns "Number of Cases" and "Number of Activities" are created in another table, you can establish a relationship between two tables, and use RELATED function.

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.