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


#1

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.

Thanks,

Rose


#2

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.