If I want to rank with in county, how can it be achieved Ex for county1, separate ranking from 1 to n For county2, separate rankingbfrom 1 to n My table contains belows columns Country, county,total deaths, rank
Hi, What if you give All(covid) instead of specifying the column name becoz the column name state is from covid table only right? Why can't we give the table name directly?
rankx(ALL(VW_NAV[Fund_Name]),CALCULATE('VW_NAV'[Return_PTP]),,DESC,Dense) Hello. By implementing the above DAX , my rank is skipping by 1 when the values become negative ( eg - 1 2 4 5 6) . Can you pls help me
Hi Bindu, I have a specific challenge need your help in solving the issue I have 10 parameters having percentages in Multiple Tables. Have derived Rank for individual parameter. Now I need to sum all the rank based on unique value that is branch name.
just one doubt cant we use both the columns in all to remove filter context since both colums are from same base table ? rather than using cross join ?
Hi Bindu, if you could also post a video about a topic 'cube.getattribute' functionality.this will be really great. In relational modelling this feature helps especially when we want to get the code of object say customer. Let's say we have customer name and we want Customer ID, then using this functionality it helps. Please enlighten us on this if possible. Thanks
Hi Ma'am why are you using cross join here. As we know we can put all the column in ALL function itself and it will remove filter from it. Can you please confirm once?
@@TheHimaBindu hello madam....ma'am from where can I get this raw data what u r explaining...I want some more data to practice..... Plz plz.....ma'am help me with this . tnQ ma'am
Ji, I need clarification on - calendarauto(3) like some ficalyearendof month value has passed. It shows data in a table. I need how these data comes on which basis?