Forum Discussion

Korekar27's avatar
Korekar27
Helper I
2 years ago

DAX

I am facing one difficult scenario. In the below image If I click on MTD it should show me MTD sales, and when I click Quantity it should show me MTD Quantity, If I click on  City it should city wise Quantity and it should be shown in the option I select in Time series. Similarly if I choose Top or bottom it should show me the result by taking in consideration the above filters whatever filter i choose. Also I should be able to choose between Top 5,10,15 Bottom,5,10,15
i am providing sample datasethttps://docs.google.com/spreadsheets/d/1A9r0UvvMjZIA3fZvqViuBXNVNz9bR9Cw/edit?usp=drive_link&ouid=117941987829098447596&rtpof=true&sd=true 

1 Reply

  • Hi Korekar27 ,

     

    How are you defining this filters? Are they field parameters?

     

    The file is asking for a password.