Forum Discussion

Ley's avatar
Ley
Icon for Helper I rankHelper I
6 years ago

selective filter in a measure

Hi, I have a distinctcount measure (total tickets).  This measure should not been filtered by table "incidencias_similares". I can not configurate this exception in " visuals interactions", and sho...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
6 years ago

Ley 

 

You may use CROSSFILTER instead and set cross-filter direction to None.

  • Ley's avatar
    Ley
    Icon for Helper I rankHelper I
    6 years ago

    It does not work. If I change crossfilter between Data and Incidencias_similares is true that "Total incidencias" is the same of "Total tickets"= CALCULATE(DISTINCTCOUNT(Data[Ticket ID]);ALL('Incidencias_similares')) wont be filtered.

    But I need that the other metric (Tickets Repetidos) to be filtered.

    This is the reason because I have tried with ALLEXCEPT and ALL to avoid filtering