Sales not to change on product

[Anonymous]

Hi Experts

i have the following DAX measure which is correct for total sales for a given manufacturing site. However, when i add the value into a tooltip, it give me the element of sales assoicated with a particular product. I want to show always the total sales. not the protion assoicated with say Product A. 

Sales Y = CALCULATE([Sales],

ALLSELECTED(PMS_COMPLAINT),

PMS_TM1_SALES_VOLUME[Fiscal Period] = "Y"

)

[v-diye-msft]

Hi @Anonymous 

Would you mind sharing your dummy pbix that I can check it further and provide the valuable solution? please kindly remove your confidential info before.

[Anonymous · Accepted solution]

Hi Microsoft team i managed to work out the DAX Measure

Sales Y = CALCULATE([Sales],

ALL(PMS_TM1_SALES_VOLUME),

PMS_TM1_SALES_VOLUME[Fiscal Period] = "Y"

)