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 ...
Need Help
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.