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 amo...
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

     

     

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