Calculated Column Measure not working on published report

[123abc]

Hi Experts,

I have issue with calculated column measure thats fine work on BI desktop but not on publsied report (shwoing YTD Sales on desktop but not on published report).

In my case i am using many table but mainly two table one is Sales Table and other is Signed Target or MOU, in Signed Target or MOU table i calculated a column with measure which calculate the sales of the following dealers who have singed the target.

I need calculated column sales against singed target for some other analytics. Requried Pics and one drive linek is given below

@

Jihwan_Kim plz can you guide me how to solve this issue.

Measure:

TotalSales =

CALCULATE(

    SUM('Sales Table'[INVQTY]),

    FILTER('Sales Table', 'Sales Table'[NewKey] = 'Signed Target or MOU'[NewKey] && 'Sales Table'[PRODUCT]='Signed Target or MOU'[ProductN]

))

PBIX File Link:

https://drive.google.com/file/d/1MNcRdp0TmyBoR4sfS7PDOdLX8hI_nGgo/view?usp=sharingSales Table and Singed Target or MOU Table relationship

published report matrix not showing YTD SalesDesktop Matrix fine showing YTD salesCalculated Column in Singed Target or MOU Table

[raji_n]

@123abc can you check if a slicer or multiple slicers are selected in the tab, Dlrs Sigend TGT Ach Status

Did you reset the slicers in Service and check, dumb question but can check still 🙂

[123abc]

Just need to re set the Dax Measure and i spent 4 days on it but cant succeeded still. 

These are not related:

can you check if a slicer or multiple slicers are selected in the tab, Dlrs Sigend TGT Ach Status

Did you reset the slicers in Service and check, dumb question but can check still