Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Create a Measure using a two different filtered visual

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

Need Help

8 Replies

  • danextian's avatar
    danextian
    Super User
    2 years ago

    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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        _AAndrade
        Resident Rockstar
        2 years ago

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