Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
You may use CROSSFILTER instead and set cross-filter direction to None.
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
The information you have provided is not making the problem clear to me. Can you please explain with an example.
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
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.
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'.
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |