Slicer value correctly shows in a card visual but not returning the TopN in a summarized table -why?

[Anonymous]

Hi,

I have created a summarized table to count the number of rows based by multiple group bys. The table formula is:
tblPacketsWithMostCandidates = SUMMARIZE(
refSCRIPT_VALIDATION,
refSCRIPT_VALIDATION[packet_id],
refSCRIPT_VALIDATION[syllabus],
refSCRIPT_VALIDATION[session_id],
refSCRIPT_VALIDATION[component],
"CountOfCandidates", COUNT( refSCRIPT_VALIDATION[candidate_number] )
)

Bringing those fields into a table visual shows (i've manually sorted it based on the CountOfCandidates):

I would like to give the user an option to pick the TopN records to view. So I created (tblNumberToView[Number]):

The value selected (5) above should be saved in a measue as follows:

mNumberToView = IF( HASONEVALUE( tblNumberToView[Number] ), VALUES( tblNumberToView[Number] ), 3 )

A card visual correctly shows the selected value (5):

I then create another summarized table to select, based on the selected TopN, the top records from the first summarized table (shown in step 1 above):
tblTopNPacketsWithMostCandidates = TOPN(
tblNumberToView[mNumberToView]
, tblPacketsWithMostCandidates
, tblPacketsWithMostCandidates[CountOfCandidates]
)

The result is:

You will notice only the Top 3 results are returned. Although the slicer value selected, and as shown in the card visual, was 5. For some reason the table is only showing the top 3, which is the default value I asked it to return in the measure to hold the slicer value.

Why is the table not returning the top CountOfCandidates based on the measure's value (5)?

Please help. Thanks in advance.

[v-chuncz-msft · Accepted solution]

@Anonymous,

A calculated table is an immutable result. You may add a measure to Visual level filters.