Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAx

HI Paul, distinct count of sales = CALCULATE ( distinctcount('fact'[order_id], FILTER ( 'Dim Channel', [Exclude Dim Channel] >= 1 ), FILTER ( 'Dim Item', [Exclude Dim Item] >= 1 ), FILTER ( 'Di...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Try

 


CALCULATE (
countrows(summarize('Fact','fact'[order_id])),
FILTER ( 'Dim Channel', [Exclude Dim Channel] >= 1 ),
FILTER ( 'Dim Item', [Exclude Dim Item] >= 1 ),
FILTER ( 'Dim REF', [Exclude Dim REF] >= 1 )
)

 

 

or

 

CALCULATE (
countrows(summarize(calculateTable('Fact',FILTER ( 'Dim Channel', [Exclude Dim Channel] >= 1 ),
FILTER ( 'Dim Item', [Exclude Dim Item] >= 1 ),
FILTER ( 'Dim REF', [Exclude Dim REF] >= 1 )
),[order_id])))