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
What is your expected result, visually, using your sample data? What numbers do you expect to see? If you could provide that then it would be eaiser for us to come up with a better solution.
Hi
I *think* this is what I'm expecting to see. I'm not sure if it is possible? I just need the data to make sense as currently it doesn't!
- v-menakakota9 months agoCommunity Support
Hi ls784 ,
Thanks for reaching out to the Microsoft fabric community forum.
Please go through the pbix which i shared.
Regards,
Microsoft Fabric Community Support Team.- v-menakakota9 months agoCommunity Support
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- v-menakakota9 months agoCommunity Support
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