Distinct count of two distinct values?

[mattthew]

 Hi all,

I wsa hoping there's a solution to this requirement.  I have a list of total orders with two distinct measures.  Needing a distinct count of the two distinct measures. 

The first measure shows below.  It takes the distinct count of orders for one column called 'On Time'

 

 The second measure shows below.  It takes the distinct count of 'In Full'

 

 They utilize the measure Total Count which in itself is a distinct count.

The problem i run into is of the 80 'In Full' and '70' On Time there are 10 duplicates.  Is there a DAX formula that could distinguish 'of the two measures there are this many duplicates' and only count them as 1?

[Ashish_Mathur]

Hi,

Share a dataset and show the expected result.  It becomes a lot easier to understand a question when one shares data rather than formulas.

[Greg_Deckler]

Could you just FILTER your SUMX tables to exclude In Full or On Time respectively?

[mattthew · Accepted solution]

Thanks for the hint and this certainly helped me rethink it.

I was able to resolve this by using CALCULATE(COUNTROWS, FILTER)