Multiselect dropdowns stored in database

Hi beakon ,

Is this what you want?

1. Enter data to create a Role table, with no relationship among other tables.

2. Create a Measure.

Measure = 
VAR SelectedRole =
    SELECTEDVALUE ( Role[Role] )
VAR ThisRoles =
    MAX ( 'Table'[Role] )
VAR Inside =
    SEARCH ( SelectedRole, ThisRoles,, 0 )
RETURN
    IF ( Inside <> 0, 1 )

3. Create other Measures filtered with [Measure].

User Name = 
CALCULATE (
    CONCATENATEX ( 'Table', 'Table'[Name], ", " ),
    FILTER ( 'Table', [Measure] = 1 )
)

Number of User = CALCULATE ( COUNTROWS( 'Table' ), FILTER ( 'Table', [Measure] = 1 ) )

Number of Role = CALCULATE ( COUNTROWS( 'Role' ), FILTER ( Role, [Measure] = 1 ) )

4. Create visuals.

For more details, please check the attached PBIX file.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.