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

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

 

PietroFarias's avatar
PietroFarias
Icon for Resolver II rankResolver II
6 years ago

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

    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.