Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Wrong Grand total Using HASONEVALUE

I am trying to get the correct grand total of work orders cost. So I am calculating and filtering in the variable and then trying to get the correct grand total. but it didnt work.        Werkor...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , try like this add all row/group by you are using in Matrix. I added only Table[Const Year]

     

    sumx(summarize(Table,Table[Const Year], "_1",[Werkorderskosten excl OH]),[_1])

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi , Anonymous 

Maybe  something wrong with the third  part of your formular.

Could you please share your PBIX/some sample data and final result to me to further research  if you don't have any Confidential Information?

 

Best Regards,
Community Support Team _ Eason