Forum Discussion
Total of Column
- 3 years ago
Hi Anonymous ,
Has your problem been resolved? If not, let me show you the detailed steps. I create a sample.
And a measure.
List of FullName values = MAX('Table'[Column])Result:
In the result, you don't want the List of FullName values show anything in the total row. Just create another measure.
Measure = IF ( ISFILTERED ( 'Table'[EnglishEducation] ), [List of FullName values], BLANK () )Result:
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Has your problem been resolved? If not, let me show you the detailed steps. I create a sample.
And a measure.
List of FullName values = MAX('Table'[Column])
Result:
In the result, you don't want the List of FullName values show anything in the total row. Just create another measure.
Measure =
IF (
ISFILTERED ( 'Table'[EnglishEducation] ),
[List of FullName values],
BLANK ()
)
Result:
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.