Forum Discussion
Remove value name in TOTAL line
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 (r...
Hi Anonymous ,
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
Under Totals in the format pane while clicking on your table. Make the font color and background color white.
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!