Home › Forums › Power Pivot › Need help filtering a column for values that begin with specific letter Tagged: calculate, dax, filter This topic contains 1 reply, has 2 voices, and was last updated by Steve Wheeler 4 years ago. Viewing 2 posts - 1 through 2 (of 2 total) Author Posts October 12, 2016 at 8:25 pm #6427 bdeuce14Participant Started: 11Replies: 14Total: 25 Hello, I’m new to DAX and trying to add a measure that will filter a column in the table by a specific value. In the table there is a column and some of the values begin with the letter “J.” I want to write a measure that will count the rows in the table for values in this column that start with “J.” I’ve attached a sample table with the arrangement of the data that I have. I created a base measure to count all of the rows in the table: Denial Transactions:=COUNTROWS(“HB Denials and Variances’) I tried writing my new measure like this: Denial Transactions for JCodes:=Calculate(Denial Transactions), [CPT Code]=”J” I know that’s not right but I’m having hard time understanding the filter piece. Attachments:You must be logged in to view attached files. October 12, 2016 at 8:33 pm #6429 Steve WheelerParticipant Started: 0Replies: 3Total: 3 Try Denial Transactions for JCodes:=Calculate([Denial Transactions], LEFT([CPT Code],1)=”J”) Author Posts Viewing 2 posts - 1 through 2 (of 2 total) The forum ‘Power Pivot’ is closed to new topics and replies.