Create a Measure using a two different filtered visual

[Anonymous]

Hi All,

Trying to work this out for quite a while, i have two visuals with different slicers for filtering, i would like to be able to use the output from the filtered viusals in another measure which is not having filtering 

For example 

Visual 1 - Filted for a date range of 1 week gives sales in that 1 week 

Visual 2 - Filted for a date range of 1 Month gives sales in that 1 Month

3rd Visual - Should be able to provide a variance % based on the values in the filtered visual 1 and Visual 2

Thanks in Advance

[_AAndrade]

Hi @Anonymous,

I'm attaching a pbix file with my solution.

[Anonymous]

Hi @_AAndrade 

Thanks a lot for your time taken to help on this my visualization currently looks like below, with slicers which can be changed dynamically the end result is the variance % = (407-301)/301, basically i need to be able to harvest the value in the filtered baselines measures to do this calculation.

[_AAndrade]

Please sendo me your pbix file and I Will take a look.

[Anonymous]

Hi @_AAndrade  Thanks for your support, please find the link to pbix file not able to upload due to restrictions in place.

Variance Calc.pbix

[_AAndrade]

Hi @Anonymous,

Take a look to the pbix file i'm attaching and see if this is what you're looking for.

[Anonymous]

Hello @_AAndrade 

The variance% should come as 78%

However as per the .pbix you shared this is 60%

Basically if you remove the measure and use the measur Weekly Baselines you in the visual it will give you a value of all the count didvided by the Unique months. What i would need is extract 355 and 1625 and store and make the required calculations. Hope that help

[_AAndrade · Accepted solution]

Hi @Anonymous,

Now I think the results are correct. Please take a look at this new pbix.

[danextian]

Hi @Anonymous ,

You will have to use two disconnected tables and three  separate measures that gets filtered based on the slicer selections from the two disconnected tables. Assuming that you'll be  filtering by date, your model would look something like below:

The two tables inside the red box are not connected to the fact table but which selection will be used to filter a measure referencing the fact table. Example measure:

Measure01 = 
CALCULATE (
    [Total Transactions],
    KEEPFILTERS ( Dates[Date] IN VALUES ( Dates01[Date] ) )
)

Measure02 = 
CALCULATE (
    [Total Transactions],
    KEEPFILTERS ( Dates[Date] IN VALUES ( Dates02[Date] ) )
)

Measure03 = 
[Measure02] - [Measure01]

Please see attached pbix for reference.