Hi!! hope you can help me! 🙂
I want to create a slicer which filters with the "User Selection" column from the following table called 'Slicer Period Table'
When the user selects Last Month, Last Qtr or Last Yr, the value that i want to get are the ones in the column "Month index", so i created this measure:
Period Selection = IF (HASONEVALUE ('Slicer Periodo Table'[User Selection]),VALUES('Slicer Period Table'[Month Index]),COUNTROWS(DimDates))
Then I want to calculate some measures that are filter by this slicer, like this:
Total Revenue = CALCULATE([Revenue], ALL(DimDates), AND(DimDates[month index]<=0, DimDates[month index]>= [Period Selection]))
The problem is that the measure gives the followig error: "A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed."
i´m very new to DAX so i don´t know how to solve it.
Unfortunately i cannot take pictures of my Data tables but i have a common sales table with every transaction that has this 4 columns:
I will always have the amount of sales up to two months before the current day. (For example if we are on April 2021, the last sales I have are from February 2020). Thats why the month index in the 'Slicer Period Table' don´t make sense.
And a DimDates table like this
Thank you!!!! 😊