Forum Discussion

123abc's avatar
123abc
Icon for Community Champion rankCommunity Champion
2 years ago

Calculated Column Measure not working on published report

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
 

 

 

Need Help

2 Replies

  • raji_n's avatar
    raji_n
    Icon for Resolver II rankResolver II
    2 years ago

    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's avatar
      123abc
      Icon for Community Champion rankCommunity Champion
      2 years ago

      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