Sum with Filters of dates in same table

[Ritaf]

Hi all, 

I have a table with data on purchases and their entries in my model (see picture.)
I need to calculate the sum of purchase values for all suppliers that have at least one entry on the year of purchase without filtering only unit entries. I need some help creating the measure for it.
The sample Pbix is on the link:
https://drive.google.com/file/d/1UtRE4MuIrKg0iwp1GlsxPp8UYvvIHJkL/view?usp=sharing

Thanks a lot, Rita

[CNENFRNL]

[Ritaf]

Hi,
Thank you for your response, but this is not what I need.
your dax is calculating all purchases, I need all purchases of suppliers that have at least 1 entry on the filtered period...
Mindik doesn't have entries in 2021 so I need to get 0 for him

[CNENFRNL · Accepted solution]

[Ritaf]

Wow!! Thank you, exactly what I need 🙂

[hnguy71]

Hi @Ritaf ,

Do you have sample output? If I understood correctly, you want to only show amounts where the entry date and purchase dates are within the same year?

If so, this is likely what you're looking for:

Sum of Purchases Same Year = CALCULATE(SUM(purchaseItems[purchaseValue]), YEAR(purchaseItems[entryDate]) = YEAR(purchaseItems[puchaseCretedon]))

[Ritaf]

HI,
Thank you for your response.
This formula is not exactly what I need because it will summarize only rows with entries.
I need to take all suppliers who have at least one entry and summarize all their purchases including the items that didn't incomed.
In the picture below the result, I want for Magnafy is 230.

[hnguy71]

@Ritaf ,

Can you tell me the logic on how you're omitting item ID 555 and 666? Or how you're including 222? Why is it only 2021 and not 2022? 

[Ritaf]

555 was with a mistake which I

corrected.
666 is correct...entry date is 08/12/2022 (8 December)

[hnguy71]

Hi @Ritaf,

Changing the date for purchase id 555 by 8 days doesn't really help me understand the exclusion logic.  Days for 555 and 666 seems to be future dates. Do you want to omit future purchase dates?

[Ritaf]

No, I want to calculate for Supplier all values by year, but I want to do it for only those who have at least one entry in the year of calculating...

[hnguy71]

Hi @Ritaf ,

Is this safe to assume so?

[Ritaf]

NO , i don't need notes
i need a calculation...

[hnguy71]

hehehe,

those notes are for me to understand where to add the numbers to. Can you confirm my understanding?

[Ritaf]

OK, and yes that's the logic