cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Frequent Visitor

## Measure for Counting Number of Batches per Month per year

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

1 ACCEPTED SOLUTION
Super User
Batches =
CALCULATE (
COUNT ( Batches[No Batches] ),
ALLEXCEPT ( Batches, Batches[Product], Batches[Month], Batches[Year] )
)

Thank you!!

2 REPLIES 2
Super User
Batches =
CALCULATE (
COUNT ( Batches[No Batches] ),
ALLEXCEPT ( Batches, Batches[Product], Batches[Month], Batches[Year] )
)

Thank you!!

Frequent Visitor

Thank you that worked 🙂

Batches =
CALCULATE (
COUNT ( 'FPA Data'[Product ] ),
ALLEXCEPT ( 'FPA Data', 'FPA Data'[Product ], 'FPA Data'[Month], 'FPA Data'[Year] ))