Forum Discussion
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
- monojchakrab
Resolver III
I found a work-around thru' power query, using group by.
But thanks for the input Anonymous
- AnonymousNot 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