Page level filter impacts the measure condition?

DAX DAX Calculations
1

Hi there,

I have created a measure that calculates the unique count of events using the following measure:

Unique_count = CALCULATE( DISTINCTCOUNT(‘Table’[Event_date]), FILTER(‘Table’,‘Table’[Notified_event]=“TRUE” ||

(‘Table’[Event_type]=“3” && ‘Table’[Status]=“1”) ))

I have also applied Table['Status]=“1” as a filter at the page level. When I ran the prog, the answer the above measure gave was 780. However, when I included the Status value “2” (along with 1) as a filter at the page level, the above measure gave a different value (i.e. 970).

As you can see in the measure that I only considering the ‘Status’ value equal to 1. I do not consider other values of the status column. I was expecting that inclusion of status value 2 in the filter would not change the count of the measure. it would remain the same. Does the page level filter overwrites the condition of measure or am I missing something here?

Sample 4.pbix (69.3 KB)

2

Hi @leo_89

Your measure has two conditions, with the OR (||) logic operator, that means when one side is valid, it is enough. In your case you have Table ’[Notified_event] =“TRUE” if that condition is valid, the second premise does not matter. Maybe you should review the logic of what you want to do.

1 Like
3

Hi @leo_89, did the response provided by @jbressan help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

4

Hi @leo_89, we’ve noticed that no response has been received from you since the 8th of March. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.