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.
Hi,
Below is the result I am getting in Power BI report. For Number of Appointments Booked, I have used the formula:
Solved! Go to Solution.
Thanks for the reply from @lbendlin , please allow me to provide another insight:
Hi @writetofaiz ,
You can try the following measure:
Test =
var _table1=
SUMMARIZE('Table',[appt_service_description],[dim_clinician_key],[dim_practice_key])
return
COUNTX(
_table1 ,[appt_service_description])
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply from @lbendlin , please allow me to provide another insight:
Hi @writetofaiz ,
You can try the following measure:
Test =
var _table1=
SUMMARIZE('Table',[appt_service_description],[dim_clinician_key],[dim_practice_key])
return
COUNTX(
_table1 ,[appt_service_description])
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Looks like you want to use DISTINCTCOUNT() rather than COUNT()
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |