hide subtotal

[nasolme]

Hi community !

I would like to keep only the grand total for "Loan" columns. 

I can use :

IF(HASONEVALUE(ASSET[ASSET_NUMBER]),blank(),sumx(SUMMARIZE(DATA,DATA[FILE_NUMBER],"average",average(DATA[ENCOURS.MT_EXPO_BRUT_Engagements])),[average]))

But logically, i get blank row  when i have only one asset number.

Somebody has an idea to correct my measure ?

[nasolme]

I didn't know this function. Thanks @SpartaBI  !!!

[SpartaBI · Accepted solution]

@nasolme 
IF(ISINSCOPE(ASSET[ASSET_NUMBER]),blank(),sumx(SUMMARIZE(DATA,DATA[FILE_NUMBER],"average",average(DATA[ENCOURS.MT_EXPO_BRUT_Engagements])),[average]))