Grand Total giving me wrong Number

[Anonymous]

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]

Hi @Anonymous 

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

SUMX(<table>, <expression>)

[v-diye-msft]

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!

[Tahreem24]

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!

[Anonymous]

Please clarify. You said "col1" should be "col1/col3"...

[Anonymous]

Its should Be col1 =  Col2/Col3. If you see the row are matching(M = V ) but Grand Total are not matching.