Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Total column value wrong

Hi, I just found that some of my column value total is not showing total instead I belive doing average even I am not usng average formula. I may need to fix Dax? Total eleven columns but only four...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi @ Greg_Deckler,

I checked that link but still unable to get it done.

 

Thanks though

 

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    You should use HASONEVALUE function to distinguish between the calculation of each date and the calculation of total. But without your sample data and expected output, I really can't help you well.

     

    Would you please inform us more detailed information( your sample data and expected output (by OneDrive for Business)) if possible?

     

    Best Regards,

    Dedmon Dai