Forum Discussion

dlkrdrf's avatar
dlkrdrf
New Member
4 months ago
Solved

Total measures show wrong total when report is published

Hi everyone, we've have a semantic model with a lot of measures, mostly SUMX(), sometimes with filter, such as, IF ("1" IN VALUES(Table[Column]), SUMX(Table[Column])). All reports are build based on...
Need Help
  • grazitti_sapna's avatar
    grazitti_sapna
    4 months ago

    Hi dlkrdrf,

     

    This is a common issue while working with SUMX() function, while it works perfect in few cases but it can change the row context while adding it to a matrix or table visuals, you can use inscope() function to cater this.

     

    Measure =
    IF(
    ISINSCOPE(Table[Column]),
    [Row Logic],
    SUMX(
    VALUES(Table[Column]),
    [Row Logic]
    )
    )

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    🔗 Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!

dlkrdrf's avatar
dlkrdrf
New Member
4 months ago

Hi grazitti_sapna ,

thanks. I'll try to add this function to the measures. We usually use many filters placed in the filters panel or as slicers on the reports. Do I need to include all these filters in the measures? Like to use multiple ISINSCOPE()?

Cheers!

grazitti_sapna's avatar
grazitti_sapna
Icon for Super User rankSuper User
4 months ago

Hi dlkrdrf,

 

No only the columns (Dimesions) which are being usen in the table or matrix view. Slicers/filters would work normally as you slice/filter the data. this is just to provide the actual row context to you measure for that paticular visual.

 

also there is an recent update (Mar'26) where you can choos how the total should be displayed. try that if that fixes your issue. take a look here