Forum Discussion

broodstar's avatar
broodstar
Regular Visitor
6 years ago
Solved

Distinctcount crashing my PC

Dear Dax users I need help or I go crazy,   I have two tables in data model - Data, Customers    Data       Customer Month Product KR 1019593 2020/06 Product...
Need Help
  • broodstar's avatar
    broodstar
    6 years ago

    I have finally substituted

     

     

    = CALCULATE

    (

      DISTINCTCOUNT(Data[Month]);

       FILTER(Data; Data[Customer] = Customers[Customer]);

       FILTER(Data; Data[Month] = Customers[Selected month])

    )

     

    by 

     

    = CALCULATE

    (

      DISTINCTCOUNT(Data[Month]);

       Data[Customer] = EARLIER(Customers[Customer]));

       Data[Month] = EARLIER(Customers[Selected month]))

    )

     

    and it works, I do not know what kind of sorcery is this, but thank you to everyone for your help 🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi broodstar ,

 

Check this formula.

Column = 
CALCULATE ( SUM ( 'Table'[KR] ), ALLEXCEPT ( 'Table', 'Table'[Customer] ) )
    / CALCULATE (
        DISTINCTCOUNT ( 'Table'[Month] ),
        ALLEXCEPT ( 'Table', 'Table'[Customer] )
    )

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

broodstar's avatar
broodstar
Regular Visitor
6 years ago

I have finally substituted

 

 

= CALCULATE

(

  DISTINCTCOUNT(Data[Month]);

   FILTER(Data; Data[Customer] = Customers[Customer]);

   FILTER(Data; Data[Month] = Customers[Selected month])

)

 

by 

 

= CALCULATE

(

  DISTINCTCOUNT(Data[Month]);

   Data[Customer] = EARLIER(Customers[Customer]));

   Data[Month] = EARLIER(Customers[Selected month]))

)

 

and it works, I do not know what kind of sorcery is this, but thank you to everyone for your help 🙂