Forum Discussion
Reflecting ranking with filter function
Hi, I am trying to work out the customer rank based on a condition. The below is the sample dataset, which reflects CustomerID, CustomerIDRank (measure-based on total amounts), Total Actuals(meas...
Hi ozlemv,
You should create a new table to show the the ranking. Please click 'New Table' under Modeling on home Page. Type the formula below and check it it returns expected result.
Selected Rank=SELECTCOLUMNS(Filter(vDetailSalesCompData,vDetailSalesCompData[CumulativeTotal]>=vDetailSalesCompData[20%GrandTotal]),"Rank",vDetailSalesCompData[CompanyID Rank ALL])
Please let me know if you have any question.
Best Regards,
Angelia