Forum Discussion

bh25's avatar
bh25
New Member
3 years ago
Solved

Dynamic Calculate Reference to Another Table

Hello, I'm having an issue trying to dynamically reference another table to pull a value. In table "Listings" I have 1000+ listings that each have a property type, of which there are approximately 10...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi bh25 ,

    Please have a try.

    CALCULATE(SUM(Escrow[Deal_Amount__c]), Escrow[Filtered Property Type] = RELATED(Listings[Property Type]))

    The RELATED function returns the related value from another table based on a relationship between the two tables.

     

    Note that you will need to make sure that there is a relationship between the two tables based on the property type column for this to work.

     

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

amitchandak's avatar
amitchandak
Super User
3 years ago

bh25 , new column way

 

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

 

 

 

Measure way

 

CALCULATE(SUM(Escrow[Deal_Amount__c]), Escrow[Filtered Property Type] =values(Table1[Table[Type]))

 

Also, consider treatas

https://docs.microsoft.com/en-us/dax/treatas-function

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/