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

    Hi Anonymous,

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

    Variance CalcAA.pbix52 KB
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.

 

Filtering using unrelated dimensions.pbix333 KB