Need help on DAX

You could add something like "IF( HASONEVALUE( Table[Deal Registration ID] ), [[your measure]], BLANK() )". Since you have more than one value for this column on the total level, but a single value for each row of your visual, this should return the same values in each row and no value on the total level.

Regards

Hi Amitkr174 ,

Measure are based on context so when you add a measure to a table/matrix the value is still calculated on the last row, depending on the values you have for aggregations the result can be different.

You can change your measure to:

Backlog Type =
IF (
    HASONEVALUE ( Table[Geo] ),
    IF (
        LASTNONBLANK ( 'ADLS Backlog'[Product], 1 ) = BLANK (),
        BLANK (),
        IF (
            SEARCH ( "TBE", LASTNONBLANK ( 'ADLS Backlog'[Product], 1 ), 1, 0 ),
            "Bill in Arrears",
            "Bill in Advance"
        )
    ),
    BLANK ()
)

You need to replace the Table[Geo] by the name of the table where the column Geo is located, you can also use any other column on your table, the idea is that if theres is a single value for geo it returns your meausre other wise is blank.