DAX Measure vs Calculated Column: Sum with complex filters

[Asa94]

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

[amitchandak]

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

Hi @amitchandak 

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

Kind Regards,

Asa