sum each Distinct counts base on slicer

[dgdgdg122db]

Hello, 

I have a measure that calculates the distinct count of customers 

CALCULATE(DISTINCTCOUNT(Orders[CustomerID]))

In my report, there is also a Segment filter ( Segment X,Y,Z) , and customers can belong to multiple Segments. 

The segment is from a segment table, consists of a customer ID column and a Segment column, customer ID column have duplicates. if

I want to return double-counted results: for example:

when one segment is selected, then return distinct count of that segment,

but when multiple segments are selected, I want to return the sum of the distinct count of customers in the selected segments 

[dgdgdg122db · Accepted solution]

I figured out, this can be done using Sumx founction 

[quangbilly79]

How?? Please post your answer? Don't just say I figured it out and quit?

[parry2k]

@dgdgdg122db can you paste sample data and the expected output Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490