Forum Discussion

LamSar's avatar
LamSar
Icon for Helper III rankHelper III
4 years ago
Solved

Dynamic TopN Slicer

Hello,

 

I have a question concerning a dynamic TOPN slicer.

 

I have the following report:

 

I want this report to show the TOPN articles based on the measure 'Top N Packages'.

I first created a topN table, with 1 column with numbers from 1 to 10

Then I created this measure; 

Number of Articles selected = SELECTEDVALUE('TopN'[Top])
 
Then I created the measure 'Aantal pakjes':  
SUMX(TicketData, TicketData[Aantal]* TicketData[#Tickets])
 
And then I created a  measure 'Top N pakjes' : 
CALCULATE([Aantal pakjes],
                TOPN([Number of Articles selected], TicketData, [Aantal pakjes], DESC))
 
But when I use the slicer nothing happens.
 
Any ideas on what I am doing wrong?
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    4 years ago

    LamSar , Try

     

    CALCULATE([Aantal pakjes],
    TOPN([Number of Articles selected], allselcted(TicketData) , [Aantal pakjes], DESC))

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    LamSar , Try

     

    CALCULATE([Aantal pakjes],
    TOPN([Number of Articles selected], allselcted(TicketData) , [Aantal pakjes], DESC))