Forum Discussion

Robyrubyjane's avatar
Robyrubyjane
Frequent Visitor
3 years ago
Solved

DAX code to Input data

hi guys I need help, so i have data like this.. and if we filter in one of data in sitename column, it'll be like this as we can see there is 4 sitename that has same name and SiteID bu...
Help me to find this DAX
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

     

     

     

    Tenant rank measure: =
IF (
    NOT ISBLANK ( MAX ( Data[rental start] ) ) && HASONEVALUE ( Site[siteID] ),
    RANKX (
        FILTER ( ALL ( Data ), Data[siteID] = SELECTEDVALUE ( Data[siteID] ) ),
        CALCULATE ( MAX ( Data[rental start] ) ),
        ,
        ASC
    )
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

 

 

 

Tenant rank measure: =
IF (
    NOT ISBLANK ( MAX ( Data[rental start] ) ) && HASONEVALUE ( Site[siteID] ),
    RANKX (
        FILTER ( ALL ( Data ), Data[siteID] = SELECTEDVALUE ( Data[siteID] ) ),
        CALCULATE ( MAX ( Data[rental start] ) ),
        ,
        ASC
    )
)