Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Total of Column

      Hi everyone, Please help me . I need your suggestions as i can not remove this text from Total row. I just need to show total of SalesAmount and not for another column. In my case i am unabl...
  • v-yanjiang-msft's avatar
    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 _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.