Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Need Help - Measure

Hello, I am a newbie to Power BI and need some help with a measure i am trying to create.   I am trying to get total cost of orders based on a look-up between 2 tables and i have the below but iti...
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    Anonymous

     

    You may modify you formula like below: 

     

    Value of Orders =
CALCULATE (
    SUM ( 'rma mm_standard_cost'[MAX_STD_COST_EA] ),
    FILTER (
        ALL ( 'rma mm_standard_cost'[MATERIAL] ),
        CONTAINS (
            VALUES ( 'rma sr_order_line'[PART_NUMBER] ),
            'rma sr_order_line'[PART_NUMBER], 'rma mm_standard_cost'[MATERIAL]
        )
    )
)

    Please also refer to this article: 

     

    From SQL to DAX: Joining Tables

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

Anonymous

 

You may modify you formula like below: 

 

Value of Orders =
CALCULATE (
    SUM ( 'rma mm_standard_cost'[MAX_STD_COST_EA] ),
    FILTER (
        ALL ( 'rma mm_standard_cost'[MATERIAL] ),
        CONTAINS (
            VALUES ( 'rma sr_order_line'[PART_NUMBER] ),
            'rma sr_order_line'[PART_NUMBER], 'rma mm_standard_cost'[MATERIAL]
        )
    )
)

Please also refer to this article: 

 

From SQL to DAX: Joining Tables

 

Regards,