Forum Discussion
Row Subtotal showing wrong
Kindly see my visual. My row subtotal is wrong.
one measure I used.
also note that Total Actual orders distinct count 148894 it is not distributing accross frozen, gocery and pershables.
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.
1 Reply
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.