Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

 

 

 

This is my relationship table.

 

 

 I can only use it for 1 filter() but not two :C 
 
 
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

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

3 Replies

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      Error is still showing: 

       

      Do you need other details? 

      • Ahmedx's avatar
        Ahmedx
        Icon for Super User rankSuper User
        3 years ago

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