Create measure for calculating rows that contain string

[alek483]

I use this to calculate rows with Parkert kasseekspedisjon:

Antall manuell rabatt = CALCULATE(COUNTROWS(KasseJournal),KasseJournal[Hendelse] = "Parkert kasseekspedisjon") + 0

But I need to be able to calculate rows with different strings. The string always contains "Manuell rabatt endret".

In excel I can use wildcard, but how can I do this in dax?

[alek483]

Thanks, this worked.

Antall manuell rabatt = CALCULATE(COUNTX(KasseJournal,KasseJournal[Brukernavn]),FILTER(KasseJournal,CONTAINSSTRING(KasseJournal[Hendelse],"Manuell rabatt endret") = TRUE())) + 0

[vicky_ · Accepted solution]

Do you mean you wnat to calculate the count of strings which contain ""Manuell rabatt endret"?
You can use CONTAINSSTRING(KasseJournal[Hendelse], "Manuell rabatt endret")
Docs here: https://learn.microsoft.com/en-us/dax/containsstring-function-dax