Forum Discussion
Rank based on two columns
Hi experts! I know, there have been a lot of posts regarding this, but they have not been useful for me. The objective is to have a ranking based on two columns. I have a dimension table (Table...
Hi joshua1990 ,
Are your Rank1 and Rank2 calculated columns or measures? There are differences between the two, please refer to
Calculated Columns and Measures in DAX - SQLBI.
Please provide some sample data, which will help me create the correct formula.
For now, you can refer to this post to try to solve it.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.