Forum Discussion
Solved
Top 2 category
Hi I have the input table as below. Is there any way to have the top 2 table ? Logic for Top 2 Table:. Finding the top 2 category by Amt , then showing up the detail of category by Route Thanks...
ngocnguyen I just called my source table Top 2 is all. See PBIX below sig.
Many thanks for your support.
However, Top 2 table is the Output, but in your Dax formular, you calling the Top 2 table?,
It 's a litte bit confusing. Could you please check again?
ngocnguyen I just called my source table Top 2 is all. See PBIX below sig.
Thanks so much. So is there any way to get the Ouput by setting up measure. I wana the Ouput can appear in the Report tab in PBI
ngocnguyen Sure, you could implement this as a Complex Selector. The Complex Selector - Microsoft Power BI Community