Home Forums Power Pivot Need help filtering a column for values that begin with specific letter

Tagged: , ,

This topic contains 1 reply, has 2 voices, and was last updated by  Steve Wheeler 5 years, 12 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #6427

    • Started: 11
    • Replies: 14
    • Total: 25


    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.

    You must be logged in to view attached files.

    Steve Wheeler
    • Started: 0
    • Replies: 3
    • Total: 3


    Denial Transactions for JCodes:=Calculate([Denial Transactions], LEFT([CPT Code],1)=”J”)

Viewing 2 posts - 1 through 2 (of 2 total)

The forum ‘Power Pivot’ is closed to new topics and replies.