How to Ignore Filter on a Specific Column in a DAX Measure

[huseyincenik_28]

Hi Community,

I need help with a DAX measure in Power BI. I want to calculate the distinct count of Partnership Event Id, but the measure should ignore filters on the investment_check column while considering other filters (e.g., partnership_check). Both measures are created on the same data.

What I Tried:

Count of Partnership Events = CALCULATE( DISTINCTCOUNT(output[Partnership Event Id]), REMOVEFILTERS(output[investment_check]) )

This doesn’t seem to work as expected.

Question:

How can I create a measure that ignores filters on investment_check but considers all other filters?

Thanks for your help!

Best,

The measure outlined in red contains REMOVEFILTERS as seen in the picture. On the other hand, the measure that should not be affected is Count of Partnership Events.

with no investment_check filter

with investment_check filter

[Ritaf1983]

Hi @huseyincenik_28 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

[huseyincenik_28]

Hello, thank you for your interest. I am sending the sample file as attachment.

https://pixeldrain.com/u/zakx8jdn

[Ritaf1983 · Accepted solution]

Hi @huseyincenik_28 
It seems working as needed ...
It ignores manipulations on the investment check slicer and reacts to others.

What am I missing...
please share a wanted result...

[huseyincenik_28]

Hello @Ritaf1983 , thank you for your interest. Although it works in the sample dashboard, as I mentioned in my first message, it does not work in the main dashboard.

Regards,

Huseyin Cenik | Data Scientist

Linkedin Account
Github Profile

[Ritaf1983]

Hi @huseyincenik_28 
If it works in the sample you attached but not in your original report, it means there are differences in the logic between them. Despite my willingness to help, I can't guess what might be wrong with something I can't see..