row subtotals matrix power bi show wrong values for distinct count

[elakkiyaselvan]

Dear Users,

I'm building matrix table Column/ rows with 2 Dimension(DatasetName/Year), Value field using Distinct count for one column.

Got wrong sub total.

Appreciate your help.

[elakkiyaselvan]

@PhilipTreacy Many thanks for your swift response got the solution from below.

https://community.fabric.microsoft.com/t5/Desktop/Matrix-and-distinct-counts-total-issue/m-p/957701

[PhilipTreacy · Accepted solution]

@elakkiyaselvan 

Please show you data and the DAX you are using to calculate the measures for the months.

Regards

Phil