Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello! Currently I have parts of this working, just not together. I have a DAX formula for the rank:
Solved! Go to Solution.
@telusive , If you are using Small multiples the you should 10 for each small multiple
use a measure like
try like
calculate([TotalNumbers],keepfilterS( topn(10, ALLSELECTED('Users'[Users]), [TotalNumbers],desc) ))
if need for all 6 week
have meausre like
M1 = calculate([M1], allselected(Date[Week]) )
calculate([TotalNumbers],keepfilterS( topn(10, ALLSELECTED('Users'[Users]), [M1],desc) ))
TOPN: https://youtu.be/QIVEFp-QiOk
TOPN with Numeric Parameter -https://youtu.be/cN8AO3_vmlY?t=26448
@telusive , If you are using Small multiples the you should 10 for each small multiple
use a measure like
try like
calculate([TotalNumbers],keepfilterS( topn(10, ALLSELECTED('Users'[Users]), [TotalNumbers],desc) ))
if need for all 6 week
have meausre like
M1 = calculate([M1], allselected(Date[Week]) )
calculate([TotalNumbers],keepfilterS( topn(10, ALLSELECTED('Users'[Users]), [M1],desc) ))
TOPN: https://youtu.be/QIVEFp-QiOk
TOPN with Numeric Parameter -https://youtu.be/cN8AO3_vmlY?t=26448
You were correct, the issue was something to do with the date itself, which I took for granted was correct. Thank you for your time.
Hey! So, the issue I have with the above is this:
I am using the first linked measure, and you can see that several week starts have less than 10 users. I assume this is because it is looking at the top 10 for the entire dataset? The only filter I have is on the date is in the last 6 weeks. I confirmed it's not just tiny by swapping them to log and still I see (this is 3 of the 6 weeks)
When I swapped to the second video logic, It's different, but the same concept.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |