@Rameez Sarang
Your issue is that you are asking DAX/Data model related question. Yet, your file only contains flat list. With no data model or schema.
DAX is highly contextual in it's nature and will evaluate differently based on context it's evaluated on.
Without knowing your data model structure, no one will be able to give you an answer. After all, we are not a m
have been trying to calculate the rank of average $values of Names selected by user and rank the names according to $value. For instance if user selects year Jan22 to Dec22, Count_type Washington and colleague Chandler &Ross the average $value for these two colleagues will be $22mn and the next colleague name Rachel will be totalling to $ 33mn so the rank of these two colleagues should be 2. I am trying to write a dax around this but I am getting an incorrect rank