Sales based on two columns

[Anonymous]

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"

)

[v-jayw-msft]

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