Forum Discussion

Kimber's avatar
Kimber
Icon for Helper III rankHelper III
1 year ago
Solved

Dax FILTER error: "The expression refers to multiple columns"

I have a table that logs student offenses. It contains data such as Student ID, Date, Offense Type and Suspension Type. I'm trying to write a simple dax filter so I can plot the number of expulsions per year on a line chart. But I'm getting this error and don't understand why:

Can someone help me with this please?

Need Help
  • Angith_Nair's avatar
    Angith_Nair
    1 year ago

    Hi Kimber 

     

    Use this DAX:

    Expulsions Per Year = 
    CALCULATE(
        COUNTROWS('Student Offenses'),
        'Student Offenses'[Suspension Type] = "Expulsion"
    )

2 Replies

  • Angith_Nair's avatar
    Angith_Nair
    Icon for Continued Contributor rankContinued Contributor
    1 year ago

    Hi Kimber 

     

    Use this DAX:

    Expulsions Per Year = 
    CALCULATE(
        COUNTROWS('Student Offenses'),
        'Student Offenses'[Suspension Type] = "Expulsion"
    )