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 this?

The issue is that the cost that I am calculating is not taking into consideration the distinct emp measure instead it is taking the count that was previously present i.e. the values before the distinctEmp measure.

Main measure:

Cost = FORMAT(SUM('table1'[Unitary Cost (cost per unit yearly)])*SUMX('table2','table2'[distinctEmp]), "Standard")
The measure that is used:
distinctEmp = DISTINCTCOUNT('table2'[Employee ID])

Thanks in advance:))

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.

2 Replies

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