topic Re: Help with measure not filtering by date in DAX Commands and Tips

Help with measure not filtering by date

Anonymous — Thu, 02 Jun 2022 04:34:42 GMT

Hi and this measure works in all ways but won't filter by date. Appreciate any thoughts? The aim of the measure is to count all those incidents that include in the text string any reference to "glass place", but exclude incidents if the word "door" is also included in the string (i.e. in the next sentence, etc). I'm not sure where to add a date filter in the measure/variable. Thanks all.

Excludes Door Incidents =

VAR _GlassPlace =

CALCULATETABLE(VALUES('Incident Detail'[Incident Code]),

SEARCH("glass place", 'Incident Detail'[Incident Details], 1, 0)>1,

'Incident Cause'[Incident Cause Code] = "MAT")

VAR _DoorsExcluded =

CALCULATETABLE(VALUES('Incident Detail'[Incident Code]),

FILTER('Incident Detail', CONTAINSSTRING('Incident Detail'[Incident Details], "door"))

Return

COUNTROWS(EXCEPT(_GlassPlace, _DoorsExcluded))

Re: Help with measure not filtering by date

SpartaBI — Thu, 02 Jun 2022 08:06:25 GMT

Anonymous hard to say with the info supplied but let's try by elimination.|
Try changing the snd var to this:

VAR _DoorsExcluded =

CALCULATETABLE(VALUES('Incident Detail'[Incident Code]),

FILTER(VALUSE('Incident Detail'[Incident Details]), CONTAINSSTRING('Incident Detail'[Incident Details], "door"))

Re: Help with measure not filtering by date

Anonymous — Fri, 03 Jun 2022 02:25:09 GMT

Hi SpartaBI and thanks for responding to this one. No luck with updating as suggested. Apols re lack of info, let me know if you have any other thoughts...

Re: Help with measure not filtering by date

SpartaBI — Fri, 03 Jun 2022 09:05:01 GMT

Anonymous I think I need to see the file in your case. Can you share it?

Re: Help with measure not filtering by date

Anonymous — Sun, 05 Jun 2022 23:50:36 GMT

Hi and unable to share unfortunately. Appreciate you taking the time to respond. Thanks agian.

Re: Help with measure not filtering by date

v-cazheng-msft — Mon, 06 Jun 2022 08:24:41 GMT

Hi Anonymous,

May I know how you would like to filter the Measure data by date filter? Do you want to count table rows when its date is equal to the selected date or before the selected date etc.? Is there any date column in your table?

If you still have problems on it, could you please provide some sample data from your tables and let me know how your create relationships for them? Thanks in advance!

Best Regards,

Community Support Team _ Caiyun