Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
13 | |
11 | |
7 |