Forum Discussion

visheshjain's avatar
visheshjain
Icon for Impactful Individual rankImpactful Individual
3 years ago

Filter Slicer from Measure values

Hello eveyone, I have 3 tables. Calendar, Sale and Parameter. Parameter has values ranging from 1-24, which are the number on months I want to go back. I am trying to filter a slicer which has ...
Need Help
Show and Tell
Tips and Tricks
visheshjain's avatar
visheshjain
Icon for Impactful Individual rankImpactful Individual
3 years ago

Hi lbendlin,

 

I have shared a sample file in message 13 of the thread. Sharing it again in this post.

 

If the calendar table is diconnected, then it will not be able to filter out data from the fact tables.

Here is a look at the data model. It is quite basic.

 

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Your measure are a little too complex.  Use these instead:

 

1 Step = EOMONTH(CALCULATE ( MAX ( 'Sales'[Sale Date] ), ALL () ),-1)

2 Step = EOMONTH([1 Step], - [Parameter Value]  ) + 1