topic Adding a Card with condition in Developer

Adding a Card with condition

VaroonA — Thu, 09 Jun 2022 02:31:30 GMT

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

Re: Adding a Card with condition

Hariharan_R — Fri, 10 Jun 2022 13:29:37 GMT

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

Re: Adding a Card with condition

VaroonA — Tue, 05 Jul 2022 01:07:22 GMT

Hi Hari!

Thanks a lot for this! It works 🙂