Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Im new to power BI and DAX and I searched everywhere and couldnt find a solution for my problem.
My problem is that Im trying to rank stores by the amount they sold in the year and Im using this formula
rankx = RANKX(ALL(resumo_consolidada[Loja]);[Faturamento];;;Dense)
this formula works fine and rank all the stores, but i just want to see the top 20 so when I use the TOP N visual filter to show only the top 20, the ranks changes like the img below
What change should I make in the formula so when I use the TOPN Visual filter the ranks dont change?
Im filtering the top 20 by using the calculated measure [faturamento] that is just a sum of the values.
Hi @luiz_borges
If I understand correctly....can you add the "amount each store sold" field to the visual level filters and sort by TopN top 20 that way?
If not, can you provide a sample report that has that issue?
@slounsbury wrote:Hi @luiz_borges
If I understand correctly....can you add the "amount each store sold" field to the visual level filters and sort by TopN top 20 that way?
If not, can you provide a sample report that has that issue?
Hmm, when I was creating the sample file for you I noticed that the error wasnt happening in the sample so when I looked to my report and removed a report level filter that I made the ranks stayed the same when I placed the top N visual filter.
Sorry for creating this topic but I never tought that a date report level filter could mess with this function.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |