DAX

[Anonymous]

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 help me with this?

@PaulDBrown 

[Fowmy · Accepted solution]

@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 )
)

[sarjensystems1]

hi @Bharat 

Have you tried doing same using 'var' ?

[Anonymous]

Hi @sarjensystems1 Thanks for the reply- I tried that but it didn't help

[sarjensystems1]

Then, instead of using measure use calculated columns by making flags (for conditions i.e. ">=1") , it might doesn't takes too much time to load calculation unlike measure.