topic Problem with generate Table with TopN in DAX Commands and Tips

Problem with generate Table with TopN

Loic_Pedro_Hans — Wed, 20 Nov 2024 08:10:56 GMT

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]),

)

RETURN

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

Thanks for your help !

Re: Problem with generate Table with TopN

johnt75 — Wed, 20 Nov 2024 16:04:22 GMT

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.

Re: Problem with generate Table with TopN

Loic_Pedro_Hans — Wed, 20 Nov 2024 16:07:40 GMT

Thank's a lot.