Forum Discussion
Table Total is not correct for a Measure column
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
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
- v-cazheng-msft
Hi, Glyndwr
To get the right Total, you can try the following solutions.
Solution 1 Create a Calculated column
Hours_col =
CALCULATE (
SUM ( 'rdowner V_ACTIVITY'[Duration ] )
* SUM ( 'rdowner V_ACTIVITY'[Number of Occurrences] ),
VALUES ( 'rdowner V_ACTIVITY'[item] )
)
Solution 2 Create two Measures
Hours_without_total =
SELECTEDVALUE ( 'rdowner V_ACTIVITY'[Duration ] )
* SELECTEDVALUE ( 'rdowner V_ACTIVITY'[Number of Occurrences] )
Hours =
IF (
HASONEFILTER ( 'rdowner V_ACTIVITY'[item] ),
[Hours_without_total],
SUMX ( 'rdowner V_ACTIVITY', [Hours_without_total] )
)
The result looks like this:
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.