cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

New Member

## Calculate sum using text wild characters.

I am trying to calulate a measure to sum the quantity of incidents where the text contains VFF.

The query i am using

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

I am getting 0 hits. But i know if have text starting with VFF.
2 ACCEPTED SOLUTIONS
Impactful Individual

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"`

Solution Sage

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

2 REPLIES 2
Solution Sage

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

Impactful Individual

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"`

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors