RANKX Customer, Profit & Transaction Date

[Anonymous]

I have a problem with RANKX.

I am currently connecting to a Tabular Model and I'm attempting to rank the profit of each customer depending on the date. I am using this formula:

Rank = RANKX(ALLSELECTED(Customer[Customer_Label]),CALCULATE([Profit]))

The tabular model is a Star schema with the Fact_Profit table being joined to both the Customer and Date tables.

This works perfectly, with the exception of 2020 and 2021 as these return only a '1':

If you look at the Profit value in the same table it looks like the following:

And I presume the reason the RANKX retrieves '1' for 2020 and 2021 is that another measure within the Profit table returns data for future years (a forecasting value).

So how would I modify the RANKX formula to filter out both 2020 and 2021. I've tried various formulas without much luck and so any help would be greatly appreciated.

[v-chuncz-msft]

@Anonymous ,

It seems that you may simply try Visual level filters.

[Anonymous]

Thanks

I know I can simply filter the data out, but I'm actually trying to understand how I can do this without the use of slicers and through the use of DAX if possible.

Kind Regards