Forum Discussion

Kazu's avatar
Kazu
Icon for Helper II rankHelper II
2 years ago

Matrix with multiple dynamic elements in each cell

Here is some sample data and visuals I would like to create. The output is essentially a matrix of Business Unit x Phase. Each intersection or cell shows all Projects of the correspoinding BU x Phase...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Kazu ,

Please try below steps:

1. create a measure with below dax formula

Measure =
VAR _a =
    SELECTEDVALUE ( 'Table'[Business Unit] )
VAR _b =
    SELECTEDVALUE ( 'Table'[Phase] )
VAR _C =
    VALUES ( 'Table'[Category] )
VAR tmp =
    CALCULATETABLE (
        VALUES ( 'Table'[Project] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Business Unit] = _a
                && 'Table'[Phase] = _b
                && 'Table'[Category] IN _C
        )
    )
VAR ctn =
    COUNTROWS ( tmp )
VAR _str =
    CONCATENATEX ( tmp, [Project], "
" )
RETURN
    _str

 

2. add a slicer and matrix visual

Please refer the attached .pbix file.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Kazu's avatar
Kazu
Icon for Helper II rankHelper II
2 years ago

Anonymous , thank you for your response. 

 

I think the measure you suggested only meets my requirement #2 but not 1 and 3. Also, I am not sure if all your "VAR" steps are needed. Can't we simply do like this?