The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have three measures.
@Sohan , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Try the first one like this and check
CALCULATE(COUNT(Afspraken[Patiëntnummer]),
FILTER(Afspraken, Afspraken[Soort afspraak]<>"Phone call" && Afspraken[Status]="Done"))
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |