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

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

Forum Discussion

Filter measure with mutiple table

Related content

Dynamic measure filtering

one or mutiple fabric capacities?

Filter by Rank measure

Using measure as a filter

Mutiple filter