Forum Discussion

unknown917's avatar
unknown917
Icon for Helper IV rankHelper IV
8 months ago
Solved

Calculating a divide for a table - what am I missing??

I have a table like below, that details cases & hrs for a large datatset.  The intent here is to calculate cases per hr.  The desired result is to be able to visualize CPH at 3 different levels:  Cum...
  • MasonMA's avatar
    MasonMA
    8 months ago

    This will work correctly at all levels, 

    Total Cases = SUM(Table[Cases])

    Total Hours = SUM(Table[Hrs])

    CPH = DIVIDE([Total Cases], [Total Hours])

                       

     

     

  • FBergamaschi's avatar
    FBergamaschi
    8 months ago

    Hi unknown917,

    can you please clairfy better what you want to achieve, showing examples of the 3 levels you are defining?

     

    1 - Cumulative with respect to what?

    2 - Unit - what do you mean here? And here the CPH would still need to be cumulative?

    3 - Hub - what do you mean here? And here the CPH would still need to be cumulative?

    Please show images and clearly point out the desired results including in case slicer etc

     

    Thanks

    If this helped, please consider giving kudos and mark as a solution

    @me in replies or I'll lose your thread

    Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

    Consider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI

     

MasonMA's avatar
MasonMA
Icon for Super User rankSuper User
8 months ago

This will work correctly at all levels, 

Total Cases = SUM(Table[Cases])

Total Hours = SUM(Table[Hrs])

CPH = DIVIDE([Total Cases], [Total Hours])

                   

 

 

unknown917's avatar
unknown917
Icon for Helper IV rankHelper IV
8 months ago

The issue with this is that when I drill down to the Bldg level, the CPH target stays the same, when it should calc the CPH at the bldg level

 

    • v-menakakota's avatar
      v-menakakota
      Icon for Community Support rankCommunity Support
      7 months ago

      Hi unknown917 ,

      Thanks for reaching out to the Microsoft fabric community forum. 

       

      I would also take a moment to thank FBergamaschi   , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

      Could you please share the images

       

       

      Best Regards, 
      Community Support Team

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        7 months ago

        Hi unknown917 ,

        I hope the issue has been resolved. If you continue to experience any problems, please reach out here and we will assist you.

        Best Regards, 
        Community Support Team