Row sum in matrix incorrect

[Anonymous]

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])
)

[v-jayw-msft]

Hi @Anonymous ,

Try creating a new measure:

Measure = SUMX(Analytics_Visitors,[Active Users])

If it deesn't work, please share some sample data so that we could test the formula.

Best Regards,

Jay

[Anonymous]

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

[amitchandak]

@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])
) )

[Anonymous]

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: