Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sales based on two columns

Hi Experts

i have got the first part of the DAX measure to work correctly, but now i want to calculate the element of the sales assoicated with the failure mode a second column in table PMS_table 2. how would i do this?

 

Sales Y = CALCULATE([Sales],
ALL(PMS_TM1_SALES_VOLUME),
PMS_TM1_SALES_VOLUME[Fiscal Period] = "Y"
)
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hi Anonymous ,

     

    Could you please share some sample data and excepted result to me if you don't have any Confidential Information?

    Best Regards,

    Jay