Calculate sum using text wild characters.

Hi There,

DAX doesnt use Operators like SQL, it only recognizes the * as text.

try this:

New VFF = calculate (sum(Query1[QTY]), LEFT(Query1[Categorized_Disposition],3) = "VFF"

Hi satish_pb ,

We can use the FIND() function to get the list of quantity of incidents where the text contains VFF, please refer to the following DAX query:

Measure =
SUMX (
    'Table',
    IF (
        FIND ( "VFF", 'Table'[Categorized_Disposition], 1, BLANK () ) = BLANK (),
        0,
        'Table'[QTY]
    )
)

The result will like below: 

Best Regards,

Teige