Forum Discussion

monojchakrab's avatar
monojchakrab
Icon for Resolver III rankResolver III
4 years ago
Solved

Filtering a ranked table by a month slicer

Hiya all,

I have a ranked table which ranks the SKUs in a group by their sales :

A. Table for ranking

SKU Rank = 
groupby('Amazon YTD','Amazon YTD'[Title],
"Sales value",
SUMX(CURRENTGROUP(),
'Amazon YTD'[Item Price])
)

B. The code for the rank column :

Rank = 
RANKX(all('SKU Rank'),
    'SKU Rank'[Sales value],,DESC,Dense
)

I have a visual (screenshot below) , wherein I want to show the top 3 SKUs by month, if I add the months as a filter on the visual :

 

the visual with the rank table

The problem is the rank table does not change if I change the month - because the SKUs are ranked on the SKU rank table.

Is there a way I can slice this rank table by month - which means the top 3 SKUs will change to show the rank of the SKUs within the month chosen?

  • I found a work-around thru' power query, using group by.

    But thanks for the input Anonymous 

2 Replies

  • I found a work-around thru' power query, using group by.

    But thanks for the input Anonymous 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi monojchakrab ,

    How about creating relationship between the tables?

     

    If I have misunderstood your meaning, please provide your desired output with more details and you sample pbix file without privacy information.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly