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...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    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.

shiva_dongari's avatar
shiva_dongari
Regular Visitor
3 years ago

Hi Anonymous 

 

You can try something like below:

 

List of FullName values =

 

VAR _result = <your current logic goes here>

 

RETURN

IF(

ISFILTERED(EnglishEducation),

_result,

blank()

)

 

If this helps, please accept my response as solution. 👍👍

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    what can i write after Var_result = 

    And how can i get a normal Total of salesAmount

    • lukiz84's avatar
      lukiz84
      Icon for Memorable Member rankMemorable Member
      3 years ago

      You have 2 measures, one for the sales amount and one for the text "List of Fullname values"... please post those 2 and we can help you.