Hello everyone,

I have a data model with: value (my sales data) / company / product / Year / Months / date (format : 01/01/2021)

To analyze this data i calculate the following measures :

YTD =CALCULATE(TOTALYTD([Sum of Value];Sales[Dte]);Sales[Attribute]="CATTC")

YTD N-1 =CALCULATE([YTD];SAMEPERIODLASTYEAR(Sales[Dte]);Sales[Attribute]="CATTC")

Moving year (my last 12 months) = CALCULATE([Sum of Value];DATESINPERIOD(Sales[Dte];MAX(Sales[Dte]);-12;MONTH);Sales[Attribute]="CATTC")

Moving year n-1 = CALCULATE([MAT];SAMEPERIODLASTYEAR(Sales[Dte]);Sales[Attribute]="CATTC")

After this calculation i add this measures to a pivot table in order to analyze this data and it perfectly works.



BUT here my question: when i add a product slicer i have the error message appearing in the attached picture, what is more strange is that i have this error message with some product and it works with others.


Capture.PNG

Any idea or tip about this issue ?