Forum Discussion
Filter table based on values from other table
I am using this DAX meassure to calculate total sales TotalSales = SUM(Sales[Amount]) and this ranking formula to rank the sales staff: RankSalesStaff = RANKX(ALL('Sales'[Staff_ID])...
Anonymous , try like
RankSalesStaff = RANKX(ALLselected('Sales'[State]),'Sales'[TotalSales])
Or
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
Thanks for your help amitchandak. How can I include the values of the STATES table into your suggested RANKX function?
Anonymous , States from Sales, I already give. If they in another table. Then if table is joined with sales use state from that table