r/excel•
bloodthinner0000

How do I create a measure in a pivot table to divide the count of a value by a value from a column from another table

unsolved

I have multiple tables that i connected through power pivot and then into a pivot table, I need to take the count of cells from a cloumn in one table and divide it by a specific value from another table.

Here's an example of the 2 tables:

Table1:

date task id 06/03/2026 task1 3 06/03/2026 task1 2 06/02/2026 task1 1

table2:

date task target 06/03/2026 task1 2 06/02/2026 task1 2

So i would need to divide the count of ids by the target, for each date and task.

I'm very new to measures, dax, and power pivot so I feel lost on how I should start approaching this and what's comsidered good practice for any future modifications.

Posted Jun 3, 2026, 11:42 AM UTC

21
Loading comments…