Forum Discussion

ssai's avatar
ssai
Frequent Visitor
3 years ago
Solved

Using one measure in another measure

Hello community:) How to use a measure in creating another measure? I have gone through some of the documentation and tutorials but when implemented I am facing issues? Can anyone help me out with t...
Need Help
Tips and Tricks
Tutorial Requests
  • AllisonKennedy's avatar
    AllisonKennedy
    3 years ago

    ssai  Relationships and context is very important. How is table1 related to table 2?

     

    You may need to use a RELATEDTABLE function, change/fix relationships, and maybe adjust your measure. 

     

    I'm thinking something like: 

     

    Cost = FORMAT(SUMX('table1', 'table1'[Unitary Cost (cost per unit yearly)] * [distinctEmp]), "Standard")

     

    but depends what you're trying to calculate.

AllisonKennedy's avatar
AllisonKennedy
Community Champion
3 years ago

ssai  Relationships and context is very important. How is table1 related to table 2?

 

You may need to use a RELATEDTABLE function, change/fix relationships, and maybe adjust your measure. 

 

I'm thinking something like: 

 

Cost = FORMAT(SUMX('table1', 'table1'[Unitary Cost (cost per unit yearly)] * [distinctEmp]), "Standard")

 

but depends what you're trying to calculate.

ssai's avatar
ssai
Frequent Visitor
3 years ago

AllisonKennedy  Thankyou very much. The one you suggessted worked perfectly.