cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ley
Helper I
Helper I

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 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:

Total tickets= CALCULATE(DISTINCTCOUNT(Data[Ticket ID]);ALL('Incidencias_similares'))
Nevertheless, with this formula I can not obtain the number of total tickets for each "Patron" and "Causa".
 
Any help?
7 REPLIES 7
v-chuncz-msft
Community Support
Community Support

@Ley 

 

You may use CROSSFILTER instead and set cross-filter direction to None.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

amitchandak
Super User
Super User

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

 

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

 

Captura.PNG

@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.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

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.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors