topic Modify DAX to return the value in the Cell in DAX Commands and Tips

Modify DAX to return the value in the Cell

KubenM — Mon, 03 Apr 2023 09:37:56 GMT

Good Day

Is it possible to modify the following DAX (was generously created by tamerj1) to return the actual value of the Cell instead of returning a Count? The BE Status as referred to in the DAX below holds values such as "To Do", "Analysis", "In Progress", etc.

The reason for my request is that I would like the actual value "Analysis" to be displayed under my Matrix column instead of the count.

BE Status =

CALCULATE (

SUM( ('Table'[BE Status]) ),

FILTER (

'Table',

VAR SelectedValues =

VALUES ( FilterTable[Item Value] )

VAR String = 'Table'[Fixed Version]

VAR Items =

SUBSTITUTE ( String, ", ", "|" )

VAR Length =

COALESCE ( PATHLENGTH ( Items ), 1 )

VAR T1 =

GENERATESERIES ( 1, Length, 1 )

VAR T2 =

SELECTCOLUMNS ( T1, "@Item", PATHITEM ( Items, [Value] ) )

RETURN

NOT ISEMPTY ( INTERSECT ( T2, SelectedValues ) ) && 'Table'[BE Status]

)

) + 0

Re: Modify DAX to return the value in the Cell

tamerj1 — Mon, 03 Apr 2023 11:18:21 GMT

Hello friend.

KubenM Please try

BE Status = CONCATENATEX ( FILTER ( 'Table', VAR SelectedValues = VALUES ( FilterTable[Item Value] ) VAR String = 'Table'[Fixed Version] VAR Items = SUBSTITUTE ( String, ", ", "|" ) VAR Length = COALESCE ( PATHLENGTH ( Items ), 1 ) VAR T1 = GENERATESERIES ( 1, Length, 1 ) VAR T2 = SELECTCOLUMNS ( T1, "@Item", PATHITEM ( Items, [Value] ) ) RETURN NOT ISEMPTY ( INTERSECT ( T2, SelectedValues ) ) ), 'Table'[BE Status], UNICHAR ( 10 ) )

Re: Modify DAX to return the value in the Cell

KubenM — Mon, 03 Apr 2023 12:50:24 GMT

Hello my Friend tamerj1 Solution works perfectly. Once again thank you for your knowledge share.