Forum Discussion
Solved
Table Total is not correct for a Measure column
I have created a Measure as: Hours = sum('rdowner V_ACTIVITY'[Duration]) * sum('rdowner V_ACTIVITY'[NumberOfOccurrences]) The Total for this column is incorrect when there are more than one rows r...
I have been experimenting and have changed from Measure to Column using:
Hours = 'rdowner V_ACTIVITY'[Duration] * 'rdowner V_ACTIVITY'[NumberOfOccurrences]This seems to work if only one row is filtered or more rows.I have been viewing introductory video by Avi Singh (https://www.youtube.com/watch?v=AGrl-H87pRU). In this he recomends using Meaure instead of Column. What is the general concensus on this please?Kind regards,Glyn
v-cazheng-msft
Community Support
Community SupportHi, Glyndwr
You can try to use HASONEFILTER function to help you deal with Measure totals issue.
For more details, you can refer Dealing with Measure Totals and Measure Totals, The Final Word.
Best Regards,
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HASONEFILTER not work. Thanks for your efforts.
Kind regards,
Glyn