Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 cor...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Please try a measure like this one:

MEASURE =
SUMX (
    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,
Gao
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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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?