I have use simple RANKX(ALL('Table'[Customer),[Total Population]) it gives the rank of all customer. Then I just add the state column and it just filtered the Rank within the states just like your result. Please advise why I need to use this lengthy DAX function which you showing.
@prathameshmunj4768
8 ай бұрын
that's right
@tushargogiya4017
Жыл бұрын
Column = var groupi='Table'[STATE] var _model=CALCULATETABLE('Table',FILTER('Table','Table'[STATE]=groupi)) return RANKX(_model,'Table'[PRICE],,ASC)
@rajeshmedapalli7026
7 ай бұрын
This measure also works as Same Final_Rank = RANKX(ALLSELECTED('Table 6'[State]),[Total Population],,DESC,Dense)
@learnwidgiggs
7 ай бұрын
Great 👍
@challanaveen1014
6 ай бұрын
the above will not work..... Answer-: final rank=RankX(allselected(Table6[customer],table6[state]),[Total population],Desc,Dense) the above query will ignore filter context of name and state and gives complete ranks based on Totalpopulation, we can put slicer for state and see individual ranks state wise.
@anupamjha827
3 ай бұрын
This doesn’t work all expect work
@anupamjha827
3 ай бұрын
@@challanaveen1014this work if we put only customer also
@rashmipatil-c6b
6 күн бұрын
State Rank = RANKX( ALL('table 6'[state]), [ total population], , DESC ) OR RANKX(ALLSELECTED('table 6'[state]), [total population], , DESC)----- we need to use external slicer for states @learnwidgiigs which is correct sir please let me know
@challanaveen1014
6 ай бұрын
simply we can get the same output by simple rankx formula directly ranks = rankx(all(customername),[totalpupulation]) here we are not ignoring state column so will get ranks by state
Fabric +copilot can impact the role power bi and advantages disadvantage you can explain it will be helpful
@learnwidgiggs
Жыл бұрын
Noted.
@sridharamanisomarajugajula6721
8 ай бұрын
why are we using first variable i.e max_state instead of writing RANKX(FILTER(ALL('Table'),'Table'[State]='Table'[State]), Can you please let me know the reason behind it & also why are we using Total Population measure, can't we use sum(population) directly in rankx function? will be helpful to understand this video if you answer this. Thank you!
I'm new to dax. Kindly provide me the roadmap to study dax and what are all the resources to use
@Mahesh717
Жыл бұрын
sir, 🙋🙋🙋 I have used this method :- Rank = Rankx(CrossJoin (All(Table(customer]), (All(Table(State]), (All(Table(Population])), [total population],, Desc,Dense) => output population 5000 = 1 population 4000 = 2 population 2500 = 3 population 1500 = 4 population 1000 = 5 population 900 = 6 population 700 = 7 population 500 = 8 Is this correct ?
@learnwidgiggs
Жыл бұрын
It looks correct.
@ragnarlodhbrok1684
6 ай бұрын
final_rk=RankX(filter(table,table[state]=earlier(table[state])),table[population],desc,,dense) do you think this would work
@sachingunjal7347
Жыл бұрын
simple way out usig Rank Rank using RANK = RANK( DENSE , All('Table 6') , ORDERBY([Total Population],DESC) ,, PARTITIONBY('Table 6'[State]) )
@VarshaPawar-mx8sn
5 ай бұрын
It's helpful
@namrataghosh111
Жыл бұрын
Really helpful scenario once again
@learnwidgiggs
Жыл бұрын
Welcome 😊
@anugyasinghal1998
10 ай бұрын
Hello Sir, thank you for this insightful video. I tried this question with the data and every time there is a error comes "circular dependency is detected" could you explain, why is this happening?
@learnwidgiggs
10 ай бұрын
Try to resolve this yourself..you will learn something new by doing this
@sanuatul3959
Жыл бұрын
Rank based on multiple columns means 3 to 4 columns. How we will do that
@shaheerbaba-0082
Ай бұрын
rank = var max_state=MAX('Sheet1'[State]) var final_rank=RANKX(FILTER(ALL('Sheet1'),'Sheet1'[State]=max_state),[Total_population],,DESC,Dense) return final_rank I am using same dax u ues bro but i am getting error: A circular dependency was detected: Sheet1[Final_Rank].help me to resolve it
@pravallikam9777
Жыл бұрын
Sir I have a doubt why we should not have many to relationships in one of your videos I saw that it gives ambiguous results ? What is ambiguous results? ....can you please explain.....what problem do we face if we have many to many relationship?
@yuvrajdalal9184
8 ай бұрын
ROWNUMBER(ALL('Table6'),ORDERBY([Population],DESC),LAST,PARTITIONBY([State])) you can try this..
@learnwidgiggs
8 ай бұрын
Thanks for the solution.
@rajm5349
Жыл бұрын
hi sir , i have a small doubt here why the state is showing two different values for single state(chennai--700,4000)
@trikavyam8101
Жыл бұрын
Hi sir,can we use earlier function as a measure to rank ..
@learnwidgiggs
Жыл бұрын
Yes here you could use it too.
@trikavyam8101
Жыл бұрын
Thank u sir
@krishnakantapanda6835
6 ай бұрын
I made use of the below dax- Rank_Test= RankX( 'Table 6', Calculate ( Sum( 'Table 6'[Population]), AllExcept( 'Table 6', 'Table 6'[state] ), DESC, DENSE )
@ashu60071
Жыл бұрын
Hi people I have downloaded new version of power bi where time intelligence function is'nt working. I have checked the options in file ribbon --> options and settings but the figures are not reflecting report. can you help me please.
@saifulislam-xq9wh
6 ай бұрын
sir please provide the data source so that we can practice
@arshithak6237
Жыл бұрын
cant we use this formula Rank= RANKX(CROSS JOIN(ALL([State]),ALL([Population])),[Population],,Desc)
@learnwidgiggs
Жыл бұрын
Try it out and then let us know the outcome
@kalyanamchakrawarty5093
Жыл бұрын
Sir mai 1 to 1 conversations karna chahta hu , regarding for my resume, interview preparation aur job se too sir mereko sabka alag alag subscription lena padega.
@learnwidgiggs
Жыл бұрын
You can book 1 slot first..then if queries complete nhi hoti hn to..you can book another session.
@shreyoshiraychaudhary8808
9 ай бұрын
What is [Total Population]?
@shreyoshiraychaudhary8808
9 ай бұрын
Hi, I have a confusion. The thing is if and when I use RankxDemo = Var state = MAX(RankxDemo[city]) Return RANKX(FILTER(All(RankxDemo),'RankxDemo'[city] = state),SUM(RankxDemo[population]),,DESC,Dense), I get 1. But when I use RankxDemo = Var state = MAX(RankxDemo[city]) Return RANKX(FILTER(All(RankxDemo),'RankxDemo'[city] = state),[Total Population],,DESC,Dense), given [Total Population] = sum('Tab'[population]), it works. Can you please explain why?
@MMullapudi
8 ай бұрын
max function is giving a different value
@adityabidkar9395
3 ай бұрын
New Column=RANKX(FILTER(ALL(Sales),Sales[State] =EARLIER(Sales[State])),Sales[Population],,DESC,Dense)
@salmanulfariskp7232
2 ай бұрын
From my side Rank = RANKX( ALLSELECTED('Table'[customer]), [Total_Population], ,DESC,Dense )
@SunilKumar-yx7fb
Жыл бұрын
Iam trying to use simple rankx but it is giving 1 for all.. what could b the error??
@learnwidgiggs
Жыл бұрын
Plz try to ..debug properly I have shown everything step by step in the video..plz watch it again
@SunilKumar-yx7fb
Жыл бұрын
@@learnwidgiggs Rank = RANKX(ALL (EMPBILLSUM[BILL CLAIMED BY]),[TotalBills], ,DESC) I dont see any syntax error or other issue. There 3 columns in the table. Is there any restriction on data types
Пікірлер: 52