Forum Discussion

Bene's avatar
Bene
Frequent Visitor
6 years ago
Solved

Missing quantities in comparative seasons

 

Hi,

I have this problem, in the fact table i have the customer, season and q.ty.

I want to know the total missing quantities not present in season 1.

the customer 1 bought in both season, so it's ok,

the customer 2 is a new customer, so it's ok,

the customer 3 bought only season 2, so this is the missing sales information I need.

Need Help
  • dax's avatar
    dax
    6 years ago

    Hi Bene , 

    You could refer to my sample for details.

    Best Regards,
    Zoe Zhi

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

     

7 Replies

    • Bene's avatar
      Bene
      Frequent Visitor
      6 years ago

      hi,

      I mean the sum of the quantities of customers who did not bought in season 1.

      thanks

      • dax's avatar
        dax
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Bene , 

        You could refer to my sample for details.

        Best Regards,
        Zoe Zhi

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

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    share your dataset and expected output.

     

    what do you mean by missing quantity?

     

     

    Thanks,

    Pravin

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    Bene ,

    Try below DAX :

     

    Quantity_Missing = CALCULATE(VALUES('Table'[Customer]),'Table'[Qty_Season2]=BLANK())
     
    Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.