Forum Discussion

hey_joo's avatar
hey_joo
New Member
6 months ago
Solved

Row subtotal did not match

The viewers count per page is 66, 10 & 3 but the total showing is only 66? I use total page user as field for viewers column.

 

 

Need Help
  • MFelix's avatar
    MFelix
    6 months ago

    Hi hey_joo ,

     

    What is the calculation that you are using for this?

     

    Depending on the way you are calculating you can get context differences because teh line totals are aggregated at a different level than the lines.

     

    You could need to use a SUMX to get the correct result overall.

  • cengizhanarslan's avatar
    cengizhanarslan
    6 months ago

    This usually happens when your measure is a DISTINCTCOUNT (or similar non-additive calculation) like Total page users / viewers. Those measures don’t add up across rows, so the subtotal/grand total will not equal the sum of visible values. If you share more detaild about the used measures here we could help you more better if needed.

3 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    6 months ago

    Hi hey_joo ,

     

    What is the calculation that you are using for this?

     

    Depending on the way you are calculating you can get context differences because teh line totals are aggregated at a different level than the lines.

     

    You could need to use a SUMX to get the correct result overall.

  • cengizhanarslan's avatar
    cengizhanarslan
    Icon for Super User rankSuper User
    6 months ago

    This usually happens when your measure is a DISTINCTCOUNT (or similar non-additive calculation) like Total page users / viewers. Those measures don’t add up across rows, so the subtotal/grand total will not equal the sum of visible values. If you share more detaild about the used measures here we could help you more better if needed.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 months ago

    Hi hey_joo,

     

    Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to MFelix and cengizhanarslan  for prompt and helpful responses.

    Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

     

    Best regards,
    Prasanna Kumar