Forum Discussion
Solved
Ignore row context for calculation
I need help to produce this visual. Requirement is to get to top rank product based on amount and then show their monthwise amount as shown in 3 different table.
Thanks for the help.
chiranjit31 , Please find the file attached file. I am getting Rank 1 for B not A
Check visual level filter
6 Replies
chiranjit31 , Try like
Measure = Rankx(allexcept(Table, Table[Product]), calculate(sum(Table[Amount])) ,, desc, dense)
Thanks for your reply. But I am not getting the exact solution. I used your measure to filter the rank to get rank 1 ,rank 2 and rank 3 .But not getting the expected result
chiranjit31 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
