Forum Discussion

Asa94's avatar
Asa94
Helper I
5 years ago

DAX Measure vs Calculated Column: Sum with complex filters

Hi all,

 

I have been trying to figure out the best way to achieve the following result:

 

1. There are multiple part numbers with various sales for each day in the month

2. I tried to create a Measure [sales] with the Filter function (per part, per month) and the EARLIER function, when I did this, I saw that I need to create a Calculated Column. Also tried SUMX

3. However, I need to reference the measure in another measure.

 

Anyone know how best to go about this scenario? Any help would be appreciated 🙂

 

Kind Regards,

Asa

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Asa94 , Calculated column can not table slicer parameter. So you have create a measure.

     

    Expected output is not clear.

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Asa94's avatar
      Asa94
      Helper I
      5 years ago

      Hi amitchandak 

       

      I will share the sample data with you 🙂 Thank you for responding.

       

      Kind Regards,

      Asa