Deleting Total in one single column?

[Anonymous]

Hello!

I have a question regarding a matrix. I want to add a "comment" column at the end (which is also in my excel data as a column) but I do not want that a comment is show up in the "total" line on the bottom. Is that somehow possible? But the other figure's total should stay. 🙂 Thanks!

[v-kelly-msft]

Hi  @Anonymous ,

Try a measure like:

Comment = IF(ISINSCOPE('Table'[category]) && MAX('Table'[value]) in {2,4},"test",IF(NOT(ISINSCOPE('Table'[category])),"test",BLANK()))

Then go to format>Subtotals -> column subtotals:off;

And you will see:

Attached is the related .pbix file if needed.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anand24]

Hi @Anonymous ,

You can also go to Format -> Field Formatting -> set font color(For only Apply to Total) to background color for hiding specific total.

Thanks !

Don't forget to give thumbs up and accept this as a solution if it helped you !!!

[Fowmy]

@Anonymous 

Try like:

Measure = IF( ISINSCOPE(Table[Column]),(MAX(Table[Comment])))

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn 

[parry2k]

@Anonymous wow never seen such a brian power for a simple question. You have now many solutions, pretty much the same.

[amitchandak]

@Anonymous , use isfiltered or isinscope

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

And create a min/max measure and use that

[parry2k · Accepted solution]

@Anonymous add a measure and use HASONEVALUE Function

Comment Measure = 
IF ( HASONEVALUE ( Table[ColumnOnRow] ), MAX ( Table[Comment] ) )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡