Forum Discussion
Show Top N values in Table
- 9 years ago
http://www.daxpatterns.com/parameter-table/
To see an example go to the bottom of the page at the above link where it says Downloads
Download the Excel 2013 zip files - extract all
Then Open PBI - File - Import - Excel Workbook Contents - Select ParametersTable - TopN - Excel 2013.xlsx - Open
click Start on the warning "We don't work directly with Excel... blah blah..." - Copy Data - Migration Completed - Close
Save the File as pbix - you may have to close and open it again
Now create a Table - place Product and TopSalesAmount in the table visual
then create a Slicer with the field from the Tp table - select any value from the slicer and see how the Measure reacts!
Hope this helps!

http://www.daxpatterns.com/parameter-table/
To see an example go to the bottom of the page at the above link where it says Downloads
Download the Excel 2013 zip files - extract all
Then Open PBI - File - Import - Excel Workbook Contents - Select ParametersTable - TopN - Excel 2013.xlsx - Open
click Start on the warning "We don't work directly with Excel... blah blah..." - Copy Data - Migration Completed - Close
Save the File as pbix - you may have to close and open it again
Now create a Table - place Product and TopSalesAmount in the table visual
then create a Slicer with the field from the Tp table - select any value from the slicer and see how the Measure reacts!
Hope this helps! 