Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |