Power BI Table Visual - Ignore row split give total to one row and blank for the other

[obriaincian]

Hi All,

I have the below table 

Split	Totals
2025	100
2024	22

I only want to sum the totals but only show the total in 2025, is there a way to do this in dax?

Desired outcome

Split	Totals
2025	122
2024	-

[Fowmy]

@obriaincian 

Use the following measure:

Total Amount = 

VAR __LatestYear = CALCULATE( MAX(Table15[Split]), REMOVEFILTERS() )
VAR __Amount = CALCULATE( SUM(Table15[Totals]) , ALLSELECTED( Table15[Split] ) )
VAR __Result = 
    IF(
        SELECTEDVALUE( Table15[Split]) = __LatestYear , __Amount , 0  
    )
RETURN
    __Result