Forum Discussion

jonathangsanto's avatar
jonathangsanto
Icon for Helper I rankHelper I
4 years ago
Solved

Filter one table from two filters

Hi All,    I have two filters "Equipment1" and "Equipment2", I want it to show me only who has the "PlacaVeiculo" with the two information, like this:   What I tried to do: I created...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

 

jonathangsanto 

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's avatar
jonathangsanto
Icon for Helper I rankHelper I
4 years ago

did it work on your model? Because in mine it still only filters by the first 😕