Problem with Cumulative Total (By Date and Vendor)

[devGV_88]

Hi folks!

I need to count rows rollling 12 month.

I was able to create the measure a show by month.

Measure: CALCULATE(DISTINCTCOUNT(Table[ID]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-12,MONTH))

But when I add onw more collumn (Vendor) from the same table I see other result.

I need the rolling in the last table to show as chart.

I need a chart like this:

Could you help me?

[amitchandak · Accepted solution]

@devGV_88 , Make sure the month is coming from the date table and date table is marked as date table.

Measure seems correct to me

Also if the same id is across two months , it will be counted once because of distinctcount