Remove value name in TOTAL line

[ahinson]

I have a table similar to this:

Unit #	Unit Name	Unit Budget
456	First	$100
123	Second	$200
789	Third	$300
Total	Second	$600

I don't want the Second unit name (red for emphasis) showing up in the total row. I just want this space to blank.

I've checked numerous formatting options but I still can't get the name to disappear. Any suggestions?

[Anonymous · Accepted solution]

Hi  @ahinson ,

Whether [Unit Name] is a measure or not, if you just want the Total line of [Unit Name] to be blank and the rest of the Total lines to be unchanged, you can experiment with the IF()+HASONEVALUE () function.

Refer to:

IF function (DAX) - DAX | Microsoft Learn

HASONEVALUE function (DAX) - DAX | Microsoft Learn

Create measure.

Measure_Unit Name =
IF(
    HASONEVALUE('Table'[Unit #]),
    [Unit Name],BLANK())

Best Regards,

Liu Yang

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

[Anonymous]

Under Totals in the format pane while clicking on your table. Make the font color and background color white.

[Anonymous]

Sure, you can use a measure like @Anonymous suggested but you can simply just format the total label like I did. Please accept this as a solution if it helped!