Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
saranp780
Helper III
Helper III

Why grand total of the columns aren't correct?

I have already performed the measurements on the table and receiving the incorrect results of the grand total. So how can I do to change the result to the correct information?

Need help.jpg

 

 

Every column is showing the grand total calculated from a measure. Terminal logon is only one from my table.

 

Please help me!!!!

 

Thank you all.

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

HI @saranp780

 

Try adding this MEASURE

 

New Save_User =
IF (
    HASONEFILTER ( Table1[UserName] ),
    [Save user],
    SUMX ( ALLSELECTED ( Table1[UserName] ), [Save user] )
)

View solution in original post

1 REPLY 1
Zubair_Muhammad
Community Champion
Community Champion

HI @saranp780

 

Try adding this MEASURE

 

New Save_User =
IF (
    HASONEFILTER ( Table1[UserName] ),
    [Save user],
    SUMX ( ALLSELECTED ( Table1[UserName] ), [Save user] )
)

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors