Forum Discussion
Row sum in matrix incorrect
Hi,
I have this problem with a matrix using as a value a measure of active users (1 if there is at least one login in the month), the total of the columns is correct, while the row totals are wrong. How can I fix it? Here is the screenshot:
Here if needed the formula used for the active users:
Active Users = CALCULATE(
DISTINCTCOUNT(Analytics_Visitors[Email]),
ALLSELECTED('calendar'[Month])
)4 Replies
Anonymous , Grand Distinctcount is not a sum of rows, it just Distinctcount again
you can try sumx(Values('calendar'[Month] ) , CALCULATE(
DISTINCTCOUNT(Analytics_Visitors[Email]),
ALLSELECTED('calendar'[Month])
) )Thank you amitchandak but if I use this formula I get again the correct columns but always the same row total (wrong) Here the screenshot:
Unfortunately it doesn't work.
the sample data could be just
User Activity Date A 25/5/2022 A 26/5/2022 B 13/5/2022 C 12/6/2022 D 24/4/2022 A 18/6/2022 So in April only D was active (active meaning at least 1 visit per month). But in May A and B were active, and in June A and C. So the matrix should be something like:
User April May June Subtotal A - 1 1 2 B - 1 - 1 C - - 1 1 D 1 - - 1 Total 1 2 2 I get totals and cells correct with this formula
Active Users = CALCULATE( DISTINCTCOUNT(Analytics_Visitors[Email]), ALLSELECTED('calendar'[Month]) )But not the subtotals
