Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

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

     

     

8 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Hi Anonymous

     

    Try this MEASURE and then put it in a CARD visual

     

    Measure =
CONCATENATEX ( VALUES ( TableName[SBU Name] ), TableName[SBU Name], "," )
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thank you..
      can you advice me when nothing is selected then only SBU : like this
      i.e noting is selected then SBU:
      when selected then SBU :dt,ies

      • v-chuncz-msft's avatar
        v-chuncz-msft
        Community Support
        8 years ago

        Anonymous,

         

        You may use measure below.

        Measure =
"SBU: "
    & IF (
        ISFILTERED ( Table1[ProjectID] ),
        CONCATENATEX ( VALUES ( Table1[SBU Name] ), Table1[SBU Name], "," )
    )