Forum Discussion

VaroonA's avatar
VaroonA
Regular Visitor
4 years ago
Solved

Adding a Card with condition

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

Need Help
  • Hariharan_R's avatar
    Hariharan_R
    4 years ago

    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

     

     

2 Replies

  • Hariharan_R's avatar
    Hariharan_R
    Solution Sage
    4 years ago

    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

     

     

  • VaroonA's avatar
    VaroonA
    Regular Visitor
    4 years ago

    Hi Hari!

    Thanks a lot for this! It works 🙂