Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Top N Filter

  Let me know if you need any further clarification.
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Share some data to work with and show the expected result.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Ashish_Mathur, Above is the example on how we need that. 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      Hi,

      Drag question to the row labels and write this measure

      Correct count = calculate(countrows(Data),Data[Response]="Correct")

      Now filter on Top 5. (in the filter pane)

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Ashish_Mathur , 

         

        The output after applying TOP 5 filter from filter pane and the DAX above worked and gave me the first output Thanks. But instead of 5 i am getting many values as 0/p. Need to get any 5 random questions as shown in the output below. If the questions are more than 5 and repeating the same time as shown below(need to get any random 5 only out of those). 

         

        Thanks,