Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 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...
Need Help
Tutorial Requests
  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    4 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.

v-xiaosun-msft's avatar
v-xiaosun-msft
Icon for Community Support rankCommunity Support
4 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.