3 Replies Latest reply: Mar 9, 2016 2:27 PM by Fahd EL YOUBI RSS

    Create a top 10 table from an already loaded excel file

    Fahd EL YOUBI

      Hi,

       

      I am coming from MS PowerBI so I am not sure how to handle this in sense. This is my DAX script:

      Top 10 Interest Areas = TOPN(10,SUMMARIZE('Individual Practice Area','Individual Practice Area'[Interest Area Id Desc Long],"Count", DISTINCTCOUNT('Individual Practice Area'[Indv Id])),[Count],DESC)

       

      I tried everything from creating this visually on the chart and using the Data Load Editor.

      Can this be achieved through the Visualization tool? if not, how can we accomplish the same result using Sense scripting language?

       

      Thanks,

      Fahd