Forum Discussion

cw900's avatar
cw900
Icon for Helper I rankHelper I
2 years ago
Solved

Line and Stacked Colum - How to Show Average on Line?

I want to show a student's login activity per day (Event_Type = "Login") as columns and I want to show the course average for the course that the student is on as the line on the same graph.   Here...
Need Help
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    In the Allexcepted put the column date that your are using in the charte.

    Allexcepted will remove all filter on that table except on the column you mention, so I think it Could solve your problem.

    Try...

_AAndrade's avatar
_AAndrade
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Try something using Allexcepted.

DAX is all about context and for that reason is important to have the right example.

In my example is working fine on my side...

cw900's avatar
cw900
Icon for Helper I rankHelper I
2 years ago

Hmmm. ALLEXCEPT looks useful but I'm struggling to work out the implementation.

 

The following measure just gives me the same average on each date.

 

New Avg v3 =
    CALCULATE(
            AVERAGE (CourseData[Total]),
            CourseData[Event_Type]="Login",
            ALLEXCEPT(CourseData, CourseData[Student_Course_Name])
    )
 

 

  • _AAndrade's avatar
    _AAndrade
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    In the Allexcepted put the column date that your are using in the charte.

    Allexcepted will remove all filter on that table except on the column you mention, so I think it Could solve your problem.

    Try...

  • cw900's avatar
    cw900
    Icon for Helper I rankHelper I
    2 years ago

    That was it 🙂

    Thank you.

  • _AAndrade's avatar
    _AAndrade
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    Great. You're welcome.