topic Re: DAX in DAX Commands and Tips

DAX

Anonymous — Wed, 27 Oct 2021 05:33:45 GMT

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

Re: DAX

sarjensystems1 — Wed, 27 Oct 2021 05:53:57 GMT

hi Bharat

Have you tried doing same using 'var' ?

Re: DAX

Anonymous — Wed, 27 Oct 2021 06:10:06 GMT

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

Re: DAX

sarjensystems1 — Wed, 27 Oct 2021 06:22:19 GMT

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.

Re: DAX

Fowmy — Wed, 27 Oct 2021 06:43:39 GMT

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