Exclude ranking for blank values with multiple columns in a table.

[harip1]

Hello,

I used Rankx function to calculate the ranking for a data.  i want to exclude the empty fields so the ranking calculates based on only the fields that has data in them.(total Revenue measure). 

Dax that am using is 

But if we want to do ranking for multiple column (from another lookup table)
How do we handle that?

Product Rank uses: Ranking by product measure

Company Rank uses:  Ranking by Sales company measure.

All i want to show ranking for product , for sales company, of total revenue by all company group,company code, product facility.

as below table.

its a very sensitive data that i cannot share much. 

any help is much appreciated.

Thanks,

Pria

[Jihwan_Kim]

Hi, @harip1 

Please correct me if I wrongly understood your question.

please try to write something like below measure for considering all dim tables.

Rank by all dimtables =

IF( not ISBLANK([Amount Total]),

RANKX( ALL(yourmainfacttable), [Amount Total], , DESC), BLANK())

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.