Forum Discussion

Ley's avatar
Ley
Helper 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
Helper 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

 

amitchandak's avatar
amitchandak
Super User
6 years ago

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.