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])...
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