Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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