Power BI Table Total
14:31 16 Jul 2026

Can anyone explain how Table Visuals figure out the Total line? In my example, Product has the wrong Total. Product is defined as C% * P%. Is it multiplying Total C% by Total P%? Is it adding up hidden rows of Product?

I'm also concerned that the other totals are just accidently correct; C% and P% should each add up to 1. Did it sum the values in the table or did I do some other operation that just happened to be the answer I expected?

Expected:

Total Product = 0.35

Actual:

Total Product = 1

Setup:

Data Source: Has 450 rows.
[Upper] is a Column.
[Count] is Measure.
[Paid] is Column.
[C%] = [Count]/(All [Count])
[P%] = [Paid]/(All [Paid])
[Product] = [C%] * [P%]

Data:

Upper Count Paid C% P% Product
A 60 $400 0.13333 0.22222 0.029630
B 150 $850 0.33333 0.47222 0.157407
C 240 $550 0.53333 0.305556 0.162963
Total 450 $1800 1 1 1
powerbi dax