Forum Discussion

Loic_Pedro_Hans's avatar
Loic_Pedro_Hans
Regular Visitor
1 year ago
Solved

Problem with generate Table with TopN

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 !
 

2 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    1 year ago

    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.