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 ?
Bookmarks