Adding a Card with condition

[VaroonA]

Hi People!

I'm new to PowerBI. I'm currently working on a report and I want to insert a card to show me some numbers based on certain conditions. 

My table has columns PersonID, Units Attempted amongst others. Each PersonID can have multiple separate Units Attempted.

My card needs to show a distinct count of PersonID when distinct count of Units Attempted is greater than 3. 

I hope that makes sense. Any help on this please?

Thanks

[VaroonA]

Hi Hari!

Thanks a lot for this! It works 🙂

[Hariharan_R · Accepted solution]

Hi

 Use the below expression.

Card =
VAR _table =
    SUMMARIZE (
        Persons,
        Persons[PersonID],
        "dCount", DISTINCTCOUNT ( Persons[UnitID] )
    )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( Persons[PersonID] ),
        FILTER ( _table, [dCount] > 3 )
    )

Sample Data,

Thanks

Hari