Forum Discussion
Matrix Totals Incorrect
- 9 months ago
Hi ls784,
Please try this
CallCount =
VAR UniqueUsers =
SUMMARIZE(
UserGroups,
UserGroups[User] -- distinct list of users in current visual context
)
RETURN
SUMX(
UniqueUsers,
VAR CurrentUser = UserGroups[User]
VAR UserCallCount =
CALCULATE(
DISTINCTCOUNT(Calls[CallID]),
FILTER(Calls, Calls[User] = CurrentUser)
)
VAR GroupCount =
CALCULATE(
DISTINCTCOUNT(UserGroups[SubGroup]),
FILTER(UserGroups, UserGroups[User] = CurrentUser)
)
RETURN DIVIDE(UserCallCount, GroupCount, 0)
)if it doesn't work, please share sample data
Hi ls784 ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Community Support Team
Hi @ls784 ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Community Support Team