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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III
Helper III

Need help with Column Total

I have a visual that contains a cloumn and a mesuare. The Total row for the Column has the correct value. The Total row for the Measure is incorrect. How can I get the Total for the mesaure to be correct. It should be 9. I'm experiencing this issue in a Table visual. My Measure contains the following: 

SUM('Adjusted'[Multiplier]) * COUNTa('OUT'[TKT_NO])


           Column     Measure 

                3                3

                3                3

                3                3

Total        9               15


Thanks for your help

Community Support
Community Support

Hi @U156531 ,

Please try a measure like this one:

    VALUES ( 'Table'[Grouping Field] ),
    SUM ( 'Adjusted'[Multiplier] ) * COUNTA ( 'OUT'[TKT_NO] )

For more information on why the totals are incorrect you can refer to:
Obtaining accurate totals in DAX - SQLBI
Why Power BI totals might seem inaccurate - SQLBI

Best Regards,

Community Support Team


If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

Gao, Thanks for the suggestion. Unfortunately that formula still gives me a Total that is much higher than what it should be. Do you have any other suggestion?

Super User
Super User

You cannot measure a measure directly. Either materialize it first, or create a separate measure that implements the entire business logic.

lbendlin, What do you mean by materializing it first?


Use it in a SUMMARIZE or SUMMARIZECOLUMNS and then SUMX over the virtual table.

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Fabric certifications survey

Certification feedback opportunity for the community.