TopN - Total value is not showing correctly

[Ramachandran]

Hi,

I'm trying to get TopN total value based on TopN slicer selection.
My sample source data

Suppose, I selected TopN value is 2 and I get 2 rows thats correct. Total row value is fetching overall value (10,500) but I want to Total value is only 5,500.

Anyone suggest me how to solve it.

I used code is below,
New Amount =
SUMX(
TOPN(
'_TopN'[TOP_N_Value],
FILTER('Sample', 'Sample'[Active Flag] = 1),
'Sample'[Amount], DESC),
'Sample'[Amount]
)

thanks,

Ram

[amitchandak · Accepted solution]

@Ramachandran , Try a measure like

calculate(sum('Sample'[Amount]), TOPN(
'_TopN'[TOP_N_Value], allselected('Sample'[Country]), 'Sample'[Amount], DESC), values('Sample'['Sample'[Country]),
FILTER('Sample', 'Sample'[Active Flag] = 1))