Skip to main content
cancel
Showing results for 
Search instead 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

Reply
CD1
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
v-shex-msft
Community Support
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.

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
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.

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

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?

Helpful resources

Announcements
Europe Fabric Conference

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 Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

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