Total of Column

[K_Vrushali]

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 unable to display anykind of Total

when i activate Total in visulaization it  shows only text and not any kind of numericalvalue. 

Thanks in Advance 

[v-yanjiang-msft · Accepted solution]

Hi @K_Vrushali ,

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.

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.

[shiva_dongari]

Hi @K_Vrushali 

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. 👍👍

[K_Vrushali]

what can i write after Var_result = 

And how can i get a normal Total of salesAmount

[lukiz84]

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.

[K_Vrushali]

Hallo dankeschön, war ist hier your Data

[lukiz84]

the measure you use to create your text,

see @shiva_dongari's reply 🙂

[lukiz84]

Change your Text Measure to:

IF (ISFILTERED(table[EnglishEducation]), yourData)