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 ( 'Dim REF', [Exclude Dim REF] >= 1 )
)
This measure is taking ages to load.Could you please alter this?

PaulDBrown 

1 Reply

  • 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])))