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