Forum Discussion
Helper Iselective 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 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:
7 Replies
- amitchandak
Super User
The information you have provided is not making the problem clear to me. Can you please explain with an example.
LeyI 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
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.
v-chuncz-msftCommunity Support
- 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
