Tricky - Second Measure to replicate the first measure and to filter similar to First Slicer

[Anonymous]

Hi Expert

What to compair two period against each other.

I am trying to create a second measure that works extactly like the first (see Slicer Current Period and measure). I need a second measure that work with the Previous Period Slicer (similar to the current Period Slicer) , and is independant of Current Period Slicer and via versa.

Slicer One comes from Periods Table and Uses Measure Actuals

Sclier two comes from Previous Table and I am trying to work this measure out..

https://www.dropbox.com/s/b3dujt78dvrwxl5/Master_.pbix?dl=0 

[Fowmy]

@Anonymous 

Your model needs to be organized and built with Cross Filter Direction to Single, currently, you have set them as Both among many tables.  The Propper model will give you better control over your model.

Your question is not clear enough to understand the exact requirement.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

Hi fowmy

See new file...

https://www.dropbox.com/s/0cjsoldsrlxuj6u/sampleData_.pbix?dl=0 

What i am trying to do is compair my current forecast to any previous forecast driven by the two slicers 

If the use selects 1+11 from current slicer they should have the option to select any forecast from previous slicer and compair the two.

Currently the month filter is not giving correct values for prior forecast, current is correct. Its 

[amitchandak]

@Anonymous , if you want to select two period based on two slicers, refer

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

This well not  work as I need all the other slicer to filter and work too...