Forum Discussion

chienbap's avatar
chienbap
Frequent Visitor
8 years ago
Solved

Make a Chart with multi choice

Hi All,   I have a problem as below: - I have a list on sharepoint with lookup field and multi choice. In each row, there are many values with comma between them. i can't make a chart with details...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi chienbap,

     

    You can use below measure to achieve your requirment:

    Total =
VAR _item =
    SELECTEDVALUE ( 'Table'[Index] )
VAR _contains =
    COUNTROWS (
        FILTER (
            ADDCOLUMNS (
                ALL ( 'Table 2' ),
                "L1", PATHITEM ( SUBSTITUTE ( [Item], ",", "|" ), 1 ),
                "L2", PATHITEM ( SUBSTITUTE ( [Item], ",", "|" ), 2 ),
                "L3", PATHITEM ( SUBSTITUTE ( [Item], ",", "|" ), 3 )
            ),
            _item IN { VALUE ( [L1] ), VALUE ( [L2] ), VALUE ( [L3] ) }
        )
    )
RETURN
    IF ( _item <> BLANK (), _contains )
        + 0

     

    Regards,

    Xiaoxin Sheng

chienbap's avatar
chienbap
Frequent Visitor
8 years ago

pls help me,

 

many thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi chienbap,

     

    You can use below measure to achieve your requirment:

    Total =
VAR _item =
    SELECTEDVALUE ( 'Table'[Index] )
VAR _contains =
    COUNTROWS (
        FILTER (
            ADDCOLUMNS (
                ALL ( 'Table 2' ),
                "L1", PATHITEM ( SUBSTITUTE ( [Item], ",", "|" ), 1 ),
                "L2", PATHITEM ( SUBSTITUTE ( [Item], ",", "|" ), 2 ),
                "L3", PATHITEM ( SUBSTITUTE ( [Item], ",", "|" ), 3 )
            ),
            _item IN { VALUE ( [L1] ), VALUE ( [L2] ), VALUE ( [L3] ) }
        )
    )
RETURN
    IF ( _item <> BLANK (), _contains )
        + 0

     

    Regards,

    Xiaoxin Sheng

    • chienbap's avatar
      chienbap
      Frequent Visitor
      8 years ago

      Hi Anonymous

       

      Thanks for your help, I have done with your instruction.

       

      Regards,