cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Lookupvalue + Sum column values in different table

Is it possible to do a “lookupvalue” in a measure from a column in a different table specified by a range and to sum that range? Are there other options?

1 ACCEPTED SOLUTION
Community Support

Hi @CD1,

Please use calculate with filter functions to instead lookupvalue, I don't think 'lookupvalue' can suitable for your requirement.

For example:

```Sum from other table =
CALCULATE (
SUM ( table[value] ),
FILTER (
ALL ( table ),
table[date] >= FIRSTDATE ( table2[date] )
&& table[date] <= LASTDATE ( table2[date] )
)
)
```

Regards,
Xiaoxin Sheng

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

Hi @CD1,

Please use calculate with filter functions to instead lookupvalue, I don't think 'lookupvalue' can suitable for your requirement.

For example:

```Sum from other table =
CALCULATE (
SUM ( table[value] ),
FILTER (
ALL ( table ),
table[date] >= FIRSTDATE ( table2[date] )
&& table[date] <= LASTDATE ( table2[date] )
)
)
```

Regards,
Xiaoxin Sheng

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

Hello
In the event that I want to do the same, but add the values according to some concept, how to do it

Helper II
Thanks for supplying this. When I'm using this solution, the problem I run into is that it appears to ignore my page filters. Is this a solution other than ALL?

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors