Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I want to count distinctcount on personid that has true in another column.
Really scratching my head right now. Anyone can give me some support in this?
PersonID | Active |
4505010101 | True |
4709010101 |
Hi @MickeLearnPBI possible solution, based on simple data sample from you and my add of two rows:
Firstly, create measure as following (replace your table name for Mytable)
Output
Proud to be a Super User!
Maybe the report can help to understand me?
Shared with you - OneDrive (live.com)
I still get the number 8 in my data, that is 6 with the value null, and 2 with true. But with this the number change while choosing another year (above is not my fully report). Do you have any idea?
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
7 | |
6 |