Measure for Counting Number of Batches per Month per year

[ScarlettBebb]

Hello 🙂

I am trying to create a measure for caluclating the number of batches of a particular product by month and year. Please is anyone able to help with the formula? 

The data looks like this;

And I want a measure that basically would give me this (I don't actually need this table I'm using the measure for a further calculated column)

Product	Month	Year	No batches
G1317CW	January	2023	2
G1317CW	February	2023	0
G1003CW	January	2023	5
G1003CW	Febuary	2023	5
G3DASCW	January	2023	5

Thank you so much for helping in advance

[Mahesh0016 · Accepted solution]

@ScarlettBebb 

Batches =

CALCULATE (

    COUNT ( Batches[No Batches] ),

    ALLEXCEPT ( Batches, Batches[Product], Batches[Month], Batches[Year] )

)

Thank you!!

[ScarlettBebb]

Thank you that worked 🙂 

Batches =

CALCULATE (

    COUNT ( 'FPA Data'[Product ] ),

    ALLEXCEPT ( 'FPA Data', 'FPA Data'[Product ], 'FPA Data'[Month], 'FPA Data'[Year] ))