Measure counting if two things are true in a row

[Anonymous]

Hi,

I have been trying to create a measure for myself to get a count showing me two things. The first is if a specific word exists in the datatable. The second being that a data column is not blank. Both things must be present in a row, and I can't seem to get this to work as it returns the wrong numbers, it seems like no matter what it concatenates the data not verifies both are true for each row. 

Below is a sample of the data and the measure i created to try and get what I am after.

Test Measure =

CALCULATE (

    COUNT('Combined Data'[Break-Fix Ticket Closed]),

    FILTER (

        ALLSELECTED('Combined Data'),

        SEARCH("SentinelOne", 'Combined Data'[Reasons],,0) && NOT(ISBLANK('Combined Data'[Break-Fix Ticket Closed]))))

Last Core Comm	OS Name	OS DisplayVersion	OS CurrentBuild	Reason	Break-Fix Ticket	Break-Fix Ticket Opened	Break-Fix Ticket Closed
44,829.95	Windows 11 Professional 64	21H2	22,000	EDR - SentinelOne		11/30/2022	12/2/2022
44,844.65	Windows 11 Professional 64	21H2	22,000	EDR - Crowdstrike, EDR - SentinelOne
44,813.72	Windows 11 Professional 64	21H2	22,000	EDR - Crowdstrike, EDR - SentinelOne
44,826.87	Windows 10 Professional 64		18,363	OS - Win10 21H2
44,848.09	Windows 10 Professional 64		18,363	OS - Win10 21H2
44,848.42	Windows 10 Enterprise 64	21H2	19,044	EDR - Cisco AMP

[v-yetao1-msft · Accepted solution]

Hi @Anonymous 

Please correct your measure like this :

Test Measure = 
CALCULATE (
    COUNT('Combined Data'[Break-Fix Ticket Closed]),
    FILTER ('Combined Data',CONTAINSSTRING(MAX('Combined Data'[Reason]),"SentinelOne")=TRUE() && 'Combined Data'[Break-Fix Ticket Closed]<>BLANK()))

Then you will get a result like this :

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