Row Subtotal showing wrong

[adnankabina]

Kindly see my visual. My row subtotal is wrong. 

one measure I used.

Actual Orders e = DISTINCTCOUNT(mfc_tracking[order_number])  please note ordrer number is string value 

Actual_Units is number value

also note that Total Actual orders distinct count 148894 it is not distributing accross frozen, gocery and pershables.

[mangaus1111 · Accepted solution]

Hi @adnankabina ,

your subtotal is not wrong!

If you use a measure with the function DISTINCTCOUNT the subtotal is never the sum of the single values,

For example if you have a simple fact table like this

the distinctcount is 2 for any single category, but it is 2 even if you consider the whole table (not filtered for category)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.