topic Re: Calculating a divide for a table - what am I missing?? in DAX Commands and Tips

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

unknown917 — Thu, 05 Mar 2026 20:22:00 GMT

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: Cumulative CPH (if no slicer selected), Unit (when selected), Hub (when selected) and finally down to the building CPH. I have no problem getting the correct number at the row level, but once I remove slicers, the calc is no longer correct. It must be simple, but I'm having a total block.

Unit	Hub	Bldg	Cases	Hrs
1	1	a	77833	1396
1	1	b	75713	1121
1	1	c	420953	6081
1	2	d	20723	515
1	2	e	242874	2769
1	2	f	189318	3233
2	3	g	364389	3777
2	3	h	809959	10862
2	3	i	426925	6403
2	4	j	119439	425
2	4	k	138445	2190
2	4	l	504590	6522

Any help would be greatly appreciated!

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

MasonMA — Thu, 05 Mar 2026 20:48:24 GMT

This will work correctly at all levels,

Total Cases = SUM(Table[Cases])

Total Hours = SUM(Table[Hrs])

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

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

FBergamaschi — Thu, 05 Mar 2026 20:49:33 GMT

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

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

unknown917 — Thu, 05 Mar 2026 21:34:21 GMT

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

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

FBergamaschi — Sun, 08 Mar 2026 12:48:16 GMT

Can you please sow images abou the issue? Otherwise we cannot help more

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

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

v-menakakota — Mon, 09 Mar 2026 06:05:04 GMT

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

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

v-menakakota — Thu, 12 Mar 2026 06:30:26 GMT

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