topic Need DAX Measure in DAX Commands and Tips

Need DAX Measure

Prakash1050 — Tue, 11 Jul 2023 13:53:10 GMT

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 contains 1 to 100 numbers.

Table B ID column and Table A Min, Max column should be connected.
If ID column is 2 means I will show 1-3 yrs in table visualization from Maturity Profile Column same like that if ID is 3 means i will show 3-5 yrs.

Please help me to done these measure.

Thanks in Advance.

I Used this below measure but shows only one Maturity Profile Value.

Years_ =

var a = SELECTEDVALUE('Table B'[ID])

var b = calculate(MAX('Table A'[Max]),'Table A'[Max] <= a)

var c = calculate(FIRSTNONBLANK('Table A'[Maturity Profile],1), 'Table A'[Max] = b)

Return c

Re: Need DAX Measure

Jihwan_Kim — Wed, 12 Jul 2023 02:44:16 GMT

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] )

Re: Need DAX Measure

Prakash1050 — Wed, 12 Jul 2023 05:18:09 GMT

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.