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

The thing is that the row "total" is still here but the "total" id is not. So I added an else : 

Ranking =
IF (
    ISINSCOPE ( table[company] ),
    RANKX (
        ALLSELECTED ( table[company] ),
        CALCULATE ( SUM ( table[Tran Amount] ) )
    ), "Total"
)

But as you can see the ranking is now decimal I don't know why