Calculated columns not updating by crossfiltering

[FFODATA]

Hi, 

I am having issues with calculated columns in a product table which are based on another table. The idea is to rank the products based on the largest volume. Therefore the two calculated columns are added to the product table.

Demand Volume = CALCULATE(SUM('Demand Table'[Qty]); FILTER('Demand Table'; 'Product'[Product Name]='Demand Table'[Product ]))

Ranking = RANK.EQ('Product'[Demand Volume];'Product'[Demand Volume];DESC)

Unfortunately, when filtering on the date in the demand table, the two calculated columns from the product table are not linked dynamically. Therefore, product A demand volume should be 245 instead of 345. 

Is there a way to ensure that this crossfiltering works dynamically on the calculated columns?

[Greg_Deckler]

Not calculated columns, you will have to convert your columns to measures.

[FFODATA]

Thanks for your reply. 

For the demand volume, a measure seems to work fine. However, how would the rank measure needs to look like? I am not able to make this one work.

[Anonymous · Accepted solution]

Hi @FFODATA,

You can create the ranking measure using the following DAX, then you will be able to get expected result when filtering date.

Ranking = RANKX(ALL('Demand Table'[Product]),'Product'[Demand Volume],,DESC)

Thanks,
Lydia Zhang