Hi @Antriksh, nice video.. Could you please explain me, why you have added the DIVIDE( [Alphabtical Rank], 100) -- Why this specially divided by 100 ? I am unable to understand this
That 100 is used to add only a small decimal number to the overall rank, it is helpful when debugging, when you see 1.01, 2.2, 3.5 you will be able to quickly decipher that actual ranks are 1, 2, and 3, if you don't divide you will see non contiguous numbers like 1, 4, 8
This is phenomenal! It worked perfectly (almost) in my use case. Thank you for this and also explaining the logic in every step. I had one question specific for my case- how would the ranks update if filter from one slicer is from a different table and the two tables are not connected?
@ankit Sharma - if I have a brand url along with rank, could please do a video or suggest the solution? It would be really appreciate for your efforts.
Hi Antriksh, first of all, awesome video, really insightful. I have been trying to do something similar but in a matrix. When i add in a second row, the ties would not be broken. Is there a work around for this that you may be able to suggest? Thanks in advance :)
Hey antriksh...good to see your channel,liked your work...i remember this technique...will always remember this....also,how about making a detailed video on removefilter and keepfilters???? Just an idea for your next video.
God bless you. You´ve saved my life..... 3 days thinking about this problem. Tks a lot.
Absolutely superb technique, Antriksh.👍✌️
Thanks Harsh!! :)
What if you need a second column filter, say in your example you wanted to filter brand and type?
Amazing explanation dear Antriksh, it was very helpful, you gained one more inscribed...thanks a lot. Regards from Brazil.
Hi @Antriksh, nice video.. Could you please explain me, why you have added the DIVIDE( [Alphabtical Rank], 100) -- Why this specially divided by 100 ? I am unable to understand this
That 100 is used to add only a small decimal number to the overall rank, it is helpful when debugging, when you see 1.01, 2.2, 3.5 you will be able to quickly decipher that actual ranks are 1, 2, and 3, if you don't divide you will see non contiguous numbers like 1, 4, 8
This is phenomenal! It worked perfectly (almost) in my use case. Thank you for this and also explaining the logic in every step. I had one question specific for my case- how would the ranks update if filter from one slicer is from a different table and the two tables are not connected?
@ankit Sharma - if I have a brand url along with rank, could please do a video or suggest the solution? It would be really appreciate for your efforts.
Greatly helped me, God bless you brother.
Hi Antriksh, first of all, awesome video, really insightful.
I have been trying to do something similar but in a matrix. When i add in a second row, the ties would not be broken. Is there a work around for this that you may be able to suggest? Thanks in advance :)
amazing solution, hats off for you.
Facing performance issue…how to solve that
Hey antriksh...good to see your channel,liked your work...i remember this technique...will always remember this....also,how about making a detailed video on removefilter and keepfilters???? Just an idea for your next video.
Thanks, will do! :)
Can you guide me what dax will be asked in interview for 2 yrs of exp?
Amazing work.Not less than a spectacular!
Thanks!! :)
Excellent solution
Really really helpful - thank you!!
And how to improve the performance? When there are lots of brand, the Dax performance is very low
Yeah, with FILTER and COUNTROWS things will be slow but you can replace FILTER + COUNTROWS with another RANKX.
@@AntrikshSharma Can you provide more detail around this? Having the same issues w/ speed
Awesome solution, THX
im ur fan sir ur awesome .
bro provide the data source