Sum of Distinct Count with drilldown

[summer18]

Hi,

I need help on getting the sum (total) of distinct count with multiple dimensions (contains drilldown) in matrix table.

LEFT chart is the pivot table from excel which should be correct values while

RIGHT chart is from PowerBI but contains wrong totals.

               

I used a sample data here.  please bear with my sample values.

Here are my files:

excel: https://drive.google.com/file/d/1kdvRUssljR2nyqPZdzTv6usHuRbIWAxt/view?usp=sharing

pbix: https://drive.google.com/file/d/1zB9wnXUe8l7VexgqJgmWuMKmm8ye_AcF/view?usp=sharing

regards,

summer

[amitchandak · Accepted solution]

@summer18 , With all columns on row of matrix 

A example measure 

sumx(summarize(Table, Table[product], Table[Segment], "_1", distinctcount(Table[dis_column])), [_1])

[summer18]

Thank you @amitchandak .  It works!  You're really a great help to me