Search code examples
sqlpowerbidaxpowerbi-desktop

Why is the filter in this calculate measure not working?

I'm creating the following measure to count the number of dimension table rows within a category in PowerBI:

TotalNonSev = Calculate(COUNT(DimCrime[CrimeNumber]), FILTER(DimCrime, DimCrime[CrimeGroup] = "least severe"))

Without the filter, the total number of columns is displayed as expected, but after the filter is added the result is blank.

Here is the actual table with the category being filtered upon - I've ensured that there are actually rows that fit the condition and that the lowercase values of CrimeGroup are the same as in the filter.

Does anyone have an idea as to why this is occurring? The solution may be very basic as I am quite new to PowerBI.

Solution

  • Keep search string in double quotes "" "".

    TotalNonSev = Calculate(COUNT(DimCrime[CrimeNumber]), FILTER(DimCrime, DimCrime[CrimeGroup] = """least severe"""))