Subtotal is not correct (sum up ) in matrix

[tranje]

Hi 

Somehow the matrix (column) is not sum up correctly, it shows the average value or something. 

Thank you in advanced for your help.

Best regards,

Jenny

[tranje]

Hi

The described problem could not be solved.

https://community.powerbi.com/t5/Desktop/Subtotal-is-not-correct-sum-up-in-matrix/m-p/2397491#M86023...

The matrix cannot sum up correctly for "total weekly"

No DAX used. Just the simply funtion from PowerBI  (count distinct)

The question is why it does not sum up. 
I have a feeling that it counts distinct instead of summing up.

If it is doing so....how can I make it summing up?

Best regards,

Jenny

[v-henryk-mstf]

Hi @tranje ,

Does it display properly after the change? Also what is the value shown for total weekly? What is the corresponding measure formula for it?

Looking forward to your feedback.

Best Regards,
Henry

[tranje]

As you can see in the picture (The "Total weekly" is not sum up correctly).

Actually, I did not use any DAX, I used the count distinct. What I did change is the formatting. 

All the configuration for formatting you can see in the answer I gave to the others. 

[amitchandak]

@tranje , Please share the measure. It may be because of row context

refer video from Curbal

https://www.youtube.com/watch?v=ufHOOLdi_jk

[tranje]

The total number of tests is based on powerbi distinct count

What I changed:
Subtotal is showing on the top and it has a band row style

[mh2587]

share your Dax please

[tranje]

The total number of tests is based on powerbi distinct count

What I changed:
Subtotal is showing on the top and it has a band row style