Forum Discussion

Wael03's avatar
Wael03
Helper I
3 years ago

Generating Row Number in Power BI Visualization

Hello !  I have a table displaying the top 20 company by total transaction amount as you can see : This table can change with filter such as the date or the country. I would like to add a co...
Wael03's avatar
Wael03
Helper I
3 years ago

Ok so I've managed to make it work using this DAX command : 

Ranking =
RANKX ( ALLSELECTED ( table[company] ), CALCULATE ( SUM ( table[Tran Amount] ) ) )

But as you can see the "Total" disappear for the "1" how can I use the DAX command only for the 20 first rows and not the total row ?

 

johnt75's avatar
johnt75
Super User
3 years ago
Ranking =
IF (
    ISINSCOPE ( table[company] ),
    RANKX (
        ALLSELECTED ( table[company] ),
        CALCULATE ( SUM ( table[Tran Amount] ) )
    )
)