Forum Discussion
Simulation using What If? parameters – calculating potential cannibalization effects
Greetings! I’ve recently started dabbling with the What If? parameters in PBI – incredible stuff that would really help our organization. Now to my question – how to make a simulation that is a p...
Hi Andursholmvik,
If you want to filter only interact with specific table records to use it simulator 'selector' effect instead of filter, I'd like to suggest you create unconnected tables(not existing relationship of raw tables) and use measure filter to apply filter effects on the visual level filter.
Applying a measure filter in Power BI - SQLBI
Understand star schema and the importance for Power BI - Power BI | Microsoft Docs
Notice:
the different filter effects will first filter on table records based on the relationships with 'AND' logic with high priority and you can't directly custom them.
Regrds,
Xiaoxin Sheng