Forum Discussion

Prakash1050's avatar
Prakash1050
Helper III
3 years ago

Need DAX Measure

 Table A Hi All,      I need Dax measure without creating relationship.      I have two tables Table A and Table B.      Table A is above the Picture and Table B have ID Column. The ID column...
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.

 

 

 

Maturity category: =
VAR _id =
    SELECTEDVALUE ( 'ID'[ID] )
RETURN
    MAXX (
        FILTER (
            Profile,
            AND ( _id >= Profile[Min], Profile[Min] <> BLANK () )
                && OR ( _id < Profile[Max], Profile[Max] = BLANK () )
        ),
        Profile[Maturity Profile]
    )
Prakash1050's avatar
Prakash1050
Helper III
3 years ago

Hi Jihwan_Kim  ,
      Thank you for your response. This Measure is working but 0 and -1 values should not showing 0-1 year that is also need. Please help me to done this scenario.