Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
This is my relationship table.
Solved! Go to Solution.
you can see what kind of error before the name [PowerBI_Appt_Code] you need to specify the name of the table
Total Attended Appointment =
CALCULATE (
COUNT ( UCS_Appointment_Data[a_appointid] ),
( 'Conversion_Code'[PowerBI_Appt_Code], POWERBI_ATTENDANCE[POWERBI_ATTENDACE] )
IN { ( "Intake Assessment", "Attended" ) }
)
pls try this
Total Attended Appointment =
CALCULATE (
COUNT ( UCS_Appointment_Data[a_appointid] ),
( [PowerBI_Appt_Code], POWERBI_ATTENDANCE[POWERBI_ATTENDACE] )
IN { ( "Intake Assessment", "Attended" ) }
)
Error is still showing:
Do you need other details?
you can see what kind of error before the name [PowerBI_Appt_Code] you need to specify the name of the table
Total Attended Appointment =
CALCULATE (
COUNT ( UCS_Appointment_Data[a_appointid] ),
( 'Conversion_Code'[PowerBI_Appt_Code], POWERBI_ATTENDANCE[POWERBI_ATTENDACE] )
IN { ( "Intake Assessment", "Attended" ) }
)