DistinctCount inside a DistinctCount

[Anonymous]

Hi,

I have in Power BI a table that stores user sign-ins and the network type of the connection.

Something like this:

User      Network Type

A              Office

A              Public

B              Office

C              Office

D              Public

I need to create a measure that counts the distinct users that has a connection to the 2 different network types so in this case only 1( the user A).

I have been trying something like this, but it's giving me as result 4, so I guess I'm not understanding the formula I'm using.

CALCULATE (DISTINCTCOUNT('Sing ins'[User]),FILTER('Sing ins',DISTINCTCOUNT('Sing ins'[Network])>1))

Can someone give some light here?

Thanks in advance!!

[AlB · Accepted solution]

Hi @Anonymous 

Measure =
COUNTROWS (
    FILTER (
        DISTINCT ( Table1[User] ),
        CALCULATE ( DISTINCTCOUNT ( Table1[Network Type] ) ) >= 2
    )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

Thanks a lot, that's perfect!!