Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

What is wrong with my filter() formula?

Total Attended Appointment = CALCULATE(COUNT(UCS_Appointment_Data[a_appointid]),FILTER(Conversion_Code,[PowerBI_Appt_Code]="Intake Assessment") && FILTER(POWERBI_ATTENDANCE,POWERBI_ATTENDANCE[POWERBI_ATTENDACE]= "Attended"))
GeraldTanwx1990_0-1688368969363.png

 

 

 

This is my relationship table.

GeraldTanwx1990_1-1688369002612.png

 

 

 I can only use it for 1 filter() but not two :C 
 
 
1 ACCEPTED 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" ) }
)

View solution in original post

3 REPLIES 3
Ahmedx
Super User
Super User

pls try this

Total Attended Appointment = 
CALCULATE (
    COUNT ( UCS_Appointment_Data[a_appointid] ),
    ( [PowerBI_Appt_Code], POWERBI_ATTENDANCE[POWERBI_ATTENDACE] )
        IN { ( "Intake Assessment", "Attended" ) }
)
Anonymous
Not applicable

Error is still showing: 

GeraldTanwx1990_0-1688376931217.png

 

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" ) }
)

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

Top Kudoed Authors