Row total in a matrix

[Anonymous]

Hi,

I have a matrix with values of distinct count of ID's but in my total i want count of it, i.e  

The total value is giving me count of distinct is my guess, but i need the actual sum of all the columns and not distinct. 

Also the columns in the matrix are days in a months from date. 

Any help is appreciated. Thank you 

[v-yulgu-msft]

Hi @Anonymous,

The total row calculates based on the detailed rows above. So, if you show distinct count in detailed rows, the total row will sum up the dixtinct count values by default.

Regards,
Yuliana Gu

[Anonymous]

@v-yulgu-msft Thanks, that sounds about right, i failed at my attempt of a work around and landed up hiding the row total as it was only a nice to have. 

Thank you all!

[Ashish_Mathur]

Hi,

Share the link from where i can download your file.

[TomMartens]

Hey,

maybe a Measure like this will do the trick

CALCULATE(
SUMX(
ALLSELECTED('yourtable'[thecolumnthatisonrows])
,DISTINCTCOUNT('thetable'[thecolumnyoucountdistinct])
)
)

If this will not work, than it will be helpful to create a pbix with sample data, upload the file to onedrive or dropbox and share the link.

Regards

Tom