display the total number of people who have selected both type

[Mark022]

I have data similar to the above and would like to make a graph.
I can drag and drop "Type" directly to value in Power BI to get the total number of people who have Type A or Type B selected, 

How can I display the total number of people who have selected both type? (TYPE A >1 AND TYPE B >1)

[ryan_mayu · Accepted solution]

@Mark022 

you can try this

A&B = 
VAR tbl=SUMMARIZE('Table','Table'[Name],"count",DISTINCTCOUNT('Table'[Type]))
return COUNTROWS(FILTER(tbl,[count]>1))

pls see the attachment below

[Mark022]

Thank you so much.

[ryan_mayu]

you are welcome

[Hariharan_R]

Hi,

Need clarity on how you got 1 for the 3 condition.

You can create one disconnected table with above 3 rows and use the below measure but need to update the "Your Condition" section.

Count =
SWITCH (
    TRUE (),
    MIN ( 'Type Table'[Types] ) = "Type A>=1",
        CALCULATE (
            COUNTROWS ( 'Type' ),
            'Type'[Type] = "Type A"
                && 'Type'[Name] <> "User B"
        ),
    MIN ( 'Type Table'[Types] ) = "Type B>=1",
        CALCULATE (
            COUNTROWS ( 'Type' ),
            'Type'[Type] = "Type B"
                && 'Type'[Name] <> "User A"
        ),
    MIN ( 'Type Table'[Types] ) = "Type A>=1 and Type B>=1", "Your Condition"
)

 Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin