topic Calculated Column Measure not working on published report in DAX Commands and Tips

Calculated Column Measure not working on published report

123abc — Fri, 09 Aug 2024 05:52:56 GMT

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=sharing

Re: Calculated Column Measure not working on published report

raji_n — Fri, 09 Aug 2024 07:18:49 GMT

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 🙂

Re: Calculated Column Measure not working on published report

123abc — Fri, 09 Aug 2024 07:39:17 GMT

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