Problem with generate Table with TopN

[Loic_Pedro_Hans]

Hi,

I create a Slicer  :

Number_Customer =

    SELECTCOLUMNS(

        {

            (1),

            (2),

            (3),

            (5),

            (10),

            (20),

            (30)

        },

        "MyNumber",[Value]

    )

When I want to generate a table with the slicer from selection, the number of clients is always 10, even I modify the slicer. the Dax to create the  table is : 

Top Retard =

VAR Nb_Clients =

    IF(

    HASONEVALUE( Number_Customer[MyNumber] ),

    VALUES (Number_Customer[MyNumber]),

    10

)

RETURN

    TOPN(Nb_Clients,'Max Retard Client','Max Retard Client'[Max Retard],ASC)

Thanks for your help !

[Loic_Pedro_Hans · Accepted solution]

Thank's a lot.

[johnt75]

Calculated tables are only calculated during data refresh, they cannot react to slicers or filters. If you need something to dynamically react to slicers you have to use a measure.