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...
Resident RockstarHi cw900,
Please try this Dax measure:
AverageCourse =
AVERAGEX(
ALL(T_Logins[Student]),
CALCULATE(
AVERAGE(T_Logins[Total])
)
)
T_Logins is my table, so you need to change this to your table name. I did some test from my side and it's working fine.
cw900Hi
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.
- _AAndrade
Please 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.