selective filter in a measure

[Ley]

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 should be indicated in DAX measure.

Nevertheless, this measure should be filtered by [Patron] and [causa] columns from "Data" table.

I have tried this formula:

Total tickets= CALCULATE(DISTINCTCOUNT(Data[Ticket ID]);ALL('Incidencias_similares'))

Nevertheless, with this formula I can not obtain the number of total tickets for each "Patron" and "Causa".

Any help?

[v-chuncz-msft]

@Ley 

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

[Ley]

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

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example.

[Ley]

I show an example,

As you can see Total incidencias Total tickets= CALCULATE(DISTINCTCOUNT(Data[Ticket ID]);ALL('Incidencias_similares'))

is not afected by filter, but it is not filtered by Patron

[amitchandak]

@Ley 

Is Patron part of data?

Try

CALCULATE(DISTINCTCOUNT(Data[Ticket ID]);ALLSELECTED('Incidencias_similares'))

CALCULATE(DISTINCTCOUNT(Data[Ticket ID]);ALL('Incidencias_similares'[Total Incidences]))

if you need more help make me @

Appreciate your Kudos.

[PietroFarias]

This 'Incidencias_similares' table refers to what in that data? Because, as you are applying an ALL, I believe it is directly linked to 'Patron'.

[Ley]

Incidencias_similares is a table that is used to create two filter (in the top of the image). Total tickets should not been filtered by Incidencias_similares.

Nevertheless, this measure should be filtered by [Patron] and [causa] columns from another table, "Data" table.