Forum Discussion
Helper ILine and Stacked Colum - How to Show Average on Line?
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...
Helper IHi
I don't think I was clear in my question. There are different courses in this table. Using that measure the average line is the same for every student because it is not taking into account the course that they are on.
Resident RockstarPlease provide one example with some data and the expected output.
I think that way would be easy to underdtand
- cw900
Here's the data:
Expected result is that when you selected Nina who is studing Geology, the line and column chart will show Nina's logins every month as columns and plot the average logins for Geology on the line.
- _AAndrade
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
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.