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

Please provide one example with some data and the expected output.

I think that way would be easy to underdtand 

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

    Please take a look it this is what you're looking for:


    My AverageCourse measure it this:

    AverageCourse = 
IF(
    NOT(ISBLANK([Count of Logins])),
    CALCULATE(
        [SimpleAvg],
        FILTER(
            ALL(T_Logins),
            T_Logins[Event_Type]="Login" && T_Logins[Student_Course_Name] IN VALUES(T_Logins[Student_Course_Name])
        )

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

      What is 

      [SimpleAvg]

      ?

       

      Also, that doesn't look right because the average value doesn't change each day. I need average value for the course on each day, so it will change every day. 

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

        cw900,

        See if this solve your problem:


        Measures:

        SimpleAvg = 
AVERAGE (T_Logins[Total])

New Avg = 
IF(
    NOT(ISBLANK([Count of Logins])),
    CALCULATE(
            [SimpleAvg],
            REMOVEFILTERS(T_Logins[Student]),
            T_Logins[Event_Type]="Login"
    )
)