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...
BrianConnelly's avatar
BrianConnelly
Icon for Resolver III rankResolver III
3 years ago

If there is an Active relationship, why don't you use the

RELATED(<column>)

function?

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..