Problem with RANKX when calculating Gain/Loss between 2 Ranked columns


I’m trying to create a visual that shows customers, LY Sales, TY Sales and Gain/Loss. My customers are ranked by Sales (top 25, next 25, other) over a 2 year period (TY and LY). When I try to use my filter to see only the customers in the 1-25 rank, the table on the left (below) WITHOUT the Gain/Loss measure displays only those customers (which is good). But as soon as I add the Gain/Loss column, the table will display ALL the customers, regardless of rank.

How can I get the table on the right to display only those customer which I have filtered out?

Sorry, I had to blank out the customers.




Adding the formulas you’re using would be helpful as it’s difficult to know without seeing anything.

Have you tried just wrapping you formula in simple IF( Some Measure = 0, BLANK(), Gain/Loss Measure)

This should do it quite easily.

closed #3