Forum Discussion

erenonem's avatar
erenonem
Frequent Visitor
3 years ago

Help with my dax

Hi all,   I m just trying to remove all my calculated columns with a measure contains a virtual table.   any chance to get any help?   //Normally I created a USD column in my Fact_XTable and SU...
erenonem's avatar
erenonem
Frequent Visitor
3 years ago

My bad, "There is no active relationship". so that couldnt use "related" function.

 

I am looking for a solution for fields that are both created as a calculated column in Power bi and fields from joins created for such purposes in SQL. If somehow I manage to use a "virtual" calculated column in a measure, then I may remove almost 100 calculated columns and many other SQL queries..

  • BrianConnelly's avatar
    BrianConnelly
    Icon for Resolver III rankResolver III
    3 years ago

    You could also use the LOOKUPVALUE fundtion?

    • erenonem's avatar
      erenonem
      Frequent Visitor
      3 years ago

      I do use Lookupfuntion in my calculated column but I do not want to create a calculated column, and I dont know jow to use any lookup function in a measure..