Forum Discussion

Milozebre's avatar
Milozebre
Icon for Helper V rankHelper V
9 years ago
Solved

Filter measure with mutiple table

Hello,   I created a measure with a filter on a table. However, I would like to add another filter from another table. Here is my measurement and I would like to add another filter in the meas...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    9 years ago

    CALCULATE can use implict filters

     

    CALCULATE( Expression, [Filter 1]; [Filter 2]; ... )

     

    So remove the explicit FILTER function:

     

    MeasureName =
CALCULATE (
    DISTINCTCOUNT ( 'Dossiers Traités-Equipe'[NumeroDossier] ),
    OR (
        'Dossiers Traités-Equipe'[EquTRAIT] = "Voiture",
        OR (
            'Dossiers Traités-Equipe'[EquTrait] = "Moto",
            OR (
                'Dossiers Traités-Equipe'[EquTrait] = "Velo",
                'Dossiers Traités-Equipe'[EquTrait] = "Bateau"
            )
        )
    )
)

     

    And you can add the new filter as another parameter (each parameter acts with an implicit AND)

     

    MeasureName =
CALCULATE (
    DISTINCTCOUNT ( 'Dossiers Traités/Equipe'[NumeroDossier] );
    OR (
        'Dossiers Traités/Equipe'[EquTRAIT] = "Voiture";
        OR (
            'Dossiers Traités/Equipe'[EquTrait] = "Moto";
            OR (
                'Dossiers Traités/Equipe'[EquTrait] = "Velo";
                'Dossiers Traités/Equipe'[EquTrait] = "Bateau"
            )
        )
    );
  'Dossiers Clos'[Libelle] = "Voiture")

     

    Hope this helps

    David

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
9 years ago

CALCULATE can use implict filters

 

CALCULATE( Expression, [Filter 1]; [Filter 2]; ... )

 

So remove the explicit FILTER function:

 

MeasureName =
CALCULATE (
    DISTINCTCOUNT ( 'Dossiers Traités-Equipe'[NumeroDossier] ),
    OR (
        'Dossiers Traités-Equipe'[EquTRAIT] = "Voiture",
        OR (
            'Dossiers Traités-Equipe'[EquTrait] = "Moto",
            OR (
                'Dossiers Traités-Equipe'[EquTrait] = "Velo",
                'Dossiers Traités-Equipe'[EquTrait] = "Bateau"
            )
        )
    )
)

 

And you can add the new filter as another parameter (each parameter acts with an implicit AND)

 

MeasureName =
CALCULATE (
    DISTINCTCOUNT ( 'Dossiers Traités/Equipe'[NumeroDossier] );
    OR (
        'Dossiers Traités/Equipe'[EquTRAIT] = "Voiture";
        OR (
            'Dossiers Traités/Equipe'[EquTrait] = "Moto";
            OR (
                'Dossiers Traités/Equipe'[EquTrait] = "Velo";
                'Dossiers Traités/Equipe'[EquTrait] = "Bateau"
            )
        )
    );
  'Dossiers Clos'[Libelle] = "Voiture")

 

Hope this helps

David

  • Milozebre's avatar
    Milozebre
    Icon for Helper V rankHelper V
    9 years ago

    Sorry for the late response but with jet lag ... :)

    Hello,

     

    I just tested the formula it works.

    I didn't know that we didn'tt have to filter with Calculate.

     

    Thanks for the information and the solution.