Forum Discussion

kjshah5030's avatar
kjshah5030
Frequent Visitor
8 years ago
Solved

Dax Top 1 Name

  Hello Everyone, I am a new to Power BI, I need a help for Dax , I have matrix table , table image is given below  so , I want to top 1 GICS Level name using High Banchmark End Weight , wan...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    kjshah5030

     

    Try with

     

    =
CALCULATE (
    MAX ( [GICS Level] ),
    FILTER (
        VALUES ( ContributionCategory[SECTOR] ),
        RANKX ( ALL ( ContributionCategory[SECTOR] ), [EndWeightBanchmark],, DESC ) = 1
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

kjshah5030

 

Could you copy paste some sample data with expected results?

 

 

 

kjshah5030's avatar
kjshah5030
Frequent Visitor
8 years ago

Hi
Zubair_Muhammad
I found one more solution , I have recently checked the value, is not blank but it is nontext value.
so now I want to use ISNONTEXT() for check whether it is text or not. I want only text value rank by desc ,
so how can I use ISNONTEXT()  in RANKX() ?

I tried but not getting proper result. so can you please help one more time?