Forum Discussion
Helper IFilter one table from two filters
Hi, jonathangsanto ;
You could try it.
Count = CALCULATE(COUNT([PlacaVeiculo]),FILTER('TabelaDistancias',[RadarBase]=MAX('Dim_Equip1'[Equipamento 1])||[RadarBase]=MAX('Dim_Equip2'[Equipamento 2])))The final output is shown below:
I can't completely reconstruct your model and what you want to output, if it's not correct, can you correct it or share a simple model?
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionTry this:
Step 1:
Make the bottom relationship inactive:
Step 2:
Create this measure:
Show =
INT(
NOT ISEMPTY(
INTERSECT(
BH_gold_base,
CALCULATETABLE(
BH_gold_base,
CROSSFILTER(BH_gold_base[ID_equip1],Dim_Equip1[ID_equip1],None),
USERELATIONSHIP(BH_gold_base[ID_equip2],Dim_Equip2[ID_equip2])
)
)
)
)
Step 3:
Put that measure in the visual level filter of the result matrix
and choose there the 1:
Is that what you meant?
Helper Ithe logic makes a lot of sense, but it still only filters by "Equipment 1", see:
The "PlacaVeiculo" BBD8249 is not on the list at 2200001
The "Placa veiculo" should only appear when both filters are true
- SpartaBI
Show = INT( NOT ISEMPTY( INTERSECT( VALUES(BH_gold_base[PlacaVeiculo]), CALCULATETABLE( VALUES(BH_gold_base[PlacaVeiculo]), CROSSFILTER(BH_gold_base[ID_equip1],Dim_Equip1[ID_equip1],None), USERELATIONSHIP(BH_gold_base[ID_equip2],Dim_Equip2[ID_equip2]) ) ) ) )- jonathangsanto
did it work on your model? Because in mine it still only filters by the first 😕