Forum Discussion
Solved
creating matrix with average value multi groupped
Hi all, Currently I've a table construct by merging other data sources. In this table a part is interesting to have a view of staffing a team. This table contains a date, an user id, a team, a w...
efhache , try measure like
averageX(Sumamrize(table, Table[weekday], "_1", count(Table[id_people])), [_1])
efhache , try measure like
averageX(Sumamrize(table, Table[weekday], "_1", count(Table[id_people])), [_1])
Thans amitchandak for the reply, but each row is a total, not an average. And I want to get the average of present people for a monday, regardin all the monday of the year.
So if we consider One monday on three is 4 peoples and other is 1... the value must be something like 1.98 people... and not 103...finally gain what I need by adding the number of week for the period. Thanks a lot
