Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
  • Fowmy's avatar
    Fowmy
    4 years ago

    Anonymous 

    Can you try the following?. 

    distinct count of sales =
CALCULATE (
    SUMX ( DISTINCT( 'fact'[order_id] ) , 1 ),
    FILTER ( 'Dim Channel', [Exclude Dim Channel] >= 1 ),
    FILTER ( 'Dim Item', [Exclude Dim Item] >= 1 ),
    FILTER ( 'Dim REF', [Exclude Dim REF] >= 1 )
)

     

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

Anonymous 

Can you try the following?. 

distinct count of sales =
CALCULATE (
    SUMX ( DISTINCT( 'fact'[order_id] ) , 1 ),
    FILTER ( 'Dim Channel', [Exclude Dim Channel] >= 1 ),
    FILTER ( 'Dim Item', [Exclude Dim Item] >= 1 ),
    FILTER ( 'Dim REF', [Exclude Dim REF] >= 1 )
)