Forum Discussion
Filtering based on several columns
I have some data structured as below - rows are individuals; each individual can belong to one or more of teams A through D, and each invidual has a certain number of clients. I'd like to create a sl...
Anonymous , Try a measure like
AverageX(Summarize(Table, Table[PERSONID], [NCLIENT]), [NCLIENT])
amitchandak
Super User
Super UserAnonymous , Unpivot and remove FALSE rows(Power query filter TRUE) , I can see most of the row has one true that will remove duplicate and you do not filter = True
I've done that, but the trouble is Person 1 belongs to two teams. So, if I am generating an "overall" average number of clients (i.e., without selecting a team on the slicer) that person gets counted twice in the computation of the average.