Re: Grand Total giving me wrong Number

Anonymous · ‎09-27-2019

Hi ,

As per the snapshot if below i m getting a wrong value for Col1 which is grand total. Ideally its Value should be Col1 / Col3 which is woring well for every row. But the Grand total dont match. the Dax columns are staright copies. =col1/col2. Can you help with the same

v-diye-msft · ‎10-08-2019

Hi @Anonymous

Please try to use SUMX function: https://docs.microsoft.com/zh-cn/dax/sumx-function-dax

SUMX(<table>, <expression>)

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

v-diye-msft · ‎10-07-2019

Hi @Anonymous

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. thanks!

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Tahreem24 · ‎09-27-2019

Hi,
As per your screenshot given there is a different value coming for row label 'E' i. e. T/U value against E is showing positive value and column 1 showing negative value.

Please correct your data accordingly.

Please give Kudos to this effort and accept this as a solution if It helps you!

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard