RankX in Direct Query

[Anonymous]

I have a table where I need to Rank Sales by their total Volume I have two merged tables to grab their names that are synced. I'm getting 1 for all people 

Rank Current Month = RANKX(ALLSELECTED(LoanMaster),CALCULATE(SUM('LoanMaster'[Loan Amount]),AllExcept(LoanMaster,LoanMaster[NMLS Loan Originator ID])),,DESC,DENSE)

I have tried everything and can't get this figured out

[v-lili6-msft]

hi, @Anonymous 

I have test on my side, it works well. If you drag the [NMLS Loan Originator ID] field in the visual?

For this formula, you must keep the [NMLS Loan Originator ID] for the row context of this measure.

If you still have the problem, please share some sample data and your expected out. There should be something wrong in other.

Best Regards,

Lin

[Anonymous]

So you're saying I have to have that column in my visual? Because it is not something I want showing. 

[v-lili6-msft]

hi, @Anonymous 

Measure is a formula that is evaluated in the context in which it is used. For example, if you use a measure in a matrix visual, the formula will be evaluated for each matrix row and column combination separately.

and this is not something you want showing, what is your expected output?

Just share some simple sample data and expected output, and i will give you right measure formula.

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Lin