Forum Discussion
split by delimiter
hii, I need output as if i select projectid 1 then SBU name as DT,IES like on card how i can ??? i.e SBU Name : DT/IES
Hi Anonymous
Just Replace ISFILTERED with ISCROSSFILTERED in the code provided by v-chuncz-msft
Measure = "SBU: " & IF ( ISCROSSFILTERED ( Table1[ProjectID] ), CONCATENATEX ( VALUES ( Table1[SBU Name] ), Table1[SBU Name], "," ) )
Hi Anonymous
Just Replace ISFILTERED with ISCROSSFILTERED in the code provided by v-chuncz-msft
Measure =
"SBU: "
& IF (
ISCROSSFILTERED ( Table1[ProjectID] ),
CONCATENATEX ( VALUES ( Table1[SBU Name] ), Table1[SBU Name], "," )
)
thanks :smileyhappy:
- It works now?
yes its works....