topic Re: Show the first 100 rows of each view / source in a table in DAX Commands and Tips

Show the first 100 rows of each view / source in a table

joshua1990 — Fri, 24 Jul 2020 10:28:15 GMT

Hello everyone!

I am currently working on a data dictionary.

I have a master data set that contains all ERP Data.

Now I would like to build 1 Report for some End User where they can filter on every source and see the first 100 rows for each source we are working with.

Is there any chance to get this in Power BI?

Is there any function that could populate every column in a table?

Re: Show the first 100 rows of each view / source in a table

Anonymous — Fri, 24 Jul 2020 11:02:39 GMT

Hi joshua1990 ,

See if this trick works for you.

https://www.youtube.com/watch?v=_sxLEGRCo28

Regards,

Harsh Nathani

Re: Show the first 100 rows of each view / source in a table

amitchandak — Fri, 24 Jul 2020 12:43:04 GMT

joshua1990 , refer if this can help

https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415