Forum Discussion
Helper IIIAdd a new Column using IF or any other functions
hello_MTC is it ok if it will be in dax? You basically need a ranking column there.
If yes, then you just want to write this calculated column:
CALC = RANKX('Table', 'Table'[user_id],,ASC,Dense)
I added a sample with differnet numbers:
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBINever mind! I solved it!
ID2 = RANKX(FILTER('actdb users_outcome','actdb users_outcome'[user_type]="Victim"),'actdb users_outcome'[user_id],,ASC,Dense)
Community Championhello_MTC can you maybe share a sample data so I could copy it to Power BI and send back the result?
Helper IIIhow to share
- SpartaBI
hello_MTC either you share a sample PBIX (through a link from onedrive/gdrive/dropbox/etc or just create a sample data in excel and copy paste the table to the message here.
- hello_MTC
Never mind! I solved it!
ID2 = RANKX(FILTER('actdb users_outcome','actdb users_outcome'[user_type]="Victim"),'actdb users_outcome'[user_id],,ASC,Dense)- SpartaBI
hello_MTC Great! 🙂
Will appreciate your kudos on my messages :))
P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas.
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂