Distinct count

Hi PBIuser_2024  you can create a measure with first month occurrance as below:

FirstMonthOccurrence =
CALCULATE(
MIN('DateTable'[MonthYear]),
ALLEXCEPT('Sales', 'Sales'[Product])
)

to get the distinct product by month which is not repeated in existing month, create one more new measure

DistinctProductsByMonth =
VAR SelectedMonthYear = MAX('DateTable'[MonthYear])
RETURN
CALCULATE(
DISTINCTCOUNT('Sales'[Product]),
FILTER(
'Sales',
[FirstMonthOccurrence] = SelectedMonthYear
)
)

drag the above measure and check each product is counted only in its first occurrence month and not in subsequent months.

Regards,

Rajendra

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.