Forum Discussion

shanebo3239's avatar
shanebo3239
Helper I
9 years ago
Solved

DAX RANKX, Filter, and ALLEXCEPT Question

All,   I have two tables in question.  Table A is the Users table.  Table B is the transactions table.  They are related by a field called userid.  They look like this:   Table A: UserId   |  Us...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    Create a Transactions Measure

    Transactions = COUNTROWS ('Table B')

    Then your Rank Measure

    Rank Users =
IF (
    HASONEVALUE ( 'Table A'[UserName] ),
    RANKX ( ALLSELECTED ( 'Table A'[UserName] ), [Transactions],, DESC, DENSE ),
    BLANK ()
)

    Then use User Name and Rank Users in a Table Visual

    drag the Transactions Measure to the Visual Level Filters ans select is greater than - type 2

     

Sean's avatar
Sean
Community Champion
9 years ago

Create a Transactions Measure

Transactions = COUNTROWS ('Table B')

Then your Rank Measure

Rank Users =
IF (
    HASONEVALUE ( 'Table A'[UserName] ),
    RANKX ( ALLSELECTED ( 'Table A'[UserName] ), [Transactions],, DESC, DENSE ),
    BLANK ()
)

Then use User Name and Rank Users in a Table Visual

drag the Transactions Measure to the Visual Level Filters ans select is greater than - type 2