Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Help with DAX Filtering

Fairly new to DAX and I'm having a hard time wrapping my head around how to use filters in the following scenario. Any help would be greatly appreciated.    I have a table like the one below which ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

In your initial post, you mention that the answer for measure1 should be 2 - how?  I think it should be 1.  Sale ID3 registered "Event A- Actual" on or before 27 January 2019.  if you want to ignore the Year 2019 and look at all "Event A- Actual" on or before 27 January 2019 then the answer should be 3 (ID1, ID2 and ID3).  I cannot understand the answer as 2 for measure 1.

Could you kinldy review your source dataset and your expected result?  Share the revised dataset and the expected result.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for your response and apologies for the delay in this response.

I havent made any changes, but I've filtered the table to show how I think the answer to measure (1) should be 2. 

On two occasions event A actually occured before 27/01/1019. 

Hope that helps clarifiy.