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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi all,

 

Can someone provide some assistance so I can learn to implement the solution described? I am new to Power BI and am looking for some more straightforward instructions to build reports and visualizations that count all unique occurances of values from a column of muli-select options in a sharepoint list.