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.

Frequent Visitor

## DAX - Search & Find question - post per Ruth (youtube)

Issue - Trying to sum (amount) with the following filters. What I have so far if you were doing it in excel the normal way
1. Calculate (Amount) - easy
2. Filter column (A) on the word Actual (easy)
Issue start here -
3. Filter column (B) where the first two numbers start with (27) and there should be a total of six numbers. Anything less or more shouldnt be counted

Thanks for any help
1 ACCEPTED SOLUTION
Community Support

Hi @Aaronjoem ,

Maybe you can try to use following measure formula if it suitable for your requirement:

```formula =
CALCULATE (
[Total Resource Amount],
FILTER (
&& LEFT ( OneLink_Report[Child Activity], 2 ) = "27"
&& LEN ( OneLink_Report[Child Activity] ) = 6
)
)
```

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
4 REPLIES 4
Community Support

HI @Aaronjoem ,

It will be help if you share some sample data and expected result for test.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Frequent Visitor

Here is a copy of my code the long way

How can I make it simpler? So far here is what I came up with. Only works 90% still include this number 27000

Community Support

Hi @Aaronjoem ,

Maybe you can try to use following measure formula if it suitable for your requirement:

```formula =
CALCULATE (
[Total Resource Amount],
FILTER (
&& LEFT ( OneLink_Report[Child Activity], 2 ) = "27"
&& LEN ( OneLink_Report[Child Activity] ) = 6
)
)
```

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Super User

Try this:

```Measure =
CALCULATE (
SUM ( Table1[Amount] );
Table1[ColumnA] = "Actual";
INT ( DIVIDE ( Table1[ColumnB]; 10000 ) ) = 27
)```

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