Create a filtered measure to count all rows if it does not start with the number 1

[benjaminhoang]

Hello trying to create a measure that count all rows that does not start with 1 but also excludes blank entries I have a sample quick measure I made which is wrong

Count of LEG-1 If does not start with 1=
CALCULATE(
COUNTA('Dispatch Total'[LEG-1]),
'Dispatch Total'[LEG-1] IN { "1" }
)

[v-chuncz-msft]

@benjaminhoang ,

By the way, you may take a look at https://www.sqlbi.com/articles/blank-handling-in-dax/.

[Zubair_Muhammad]

@benjaminhoang 

Try with following

Count of LEG-1 If does not start with 1 =
CALCULATE (
    COUNT ( 'Dispatch Total'[LEG-1] ),
    NOT 'Dispatch Total'[LEG-1] IN { "1", BLANK () }
)

[benjaminhoang]

DId I do something wrong it is counting its that start with 1

[v-chuncz-msft]

@benjaminhoang ,

You'll need to use LEFT first.

[benjaminhoang]

https://community.powerbi.com/t5/Desktop/Adding-3-columns-together-to-get-a-total-to-show-on-a-card/...