Colum Calculated Measure fine work on BI Desktop but not 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=sharing

Desktop Matrix fine showing YTD salespublished report matrix not showing YTD SalesSales Table and Singed Target or MOU Table relationshipCalculated Column in Singed Target or MOU Table

[SachinNandanwar]

Have you tried converting one of those calculated columns to a measure ?

[123abc]

i need calculated column not regular measure bcz this calculted column are using furhter column for my analysis like :

YTD Ach % REF = DIVIDE('Signed Target or MOU'[TotalSales],'Signed Target or MOU'[YTM Target Actual]).

AchievementSlab =

SWITCH(

    TRUE(),

    'Signed Target or MOU'[YTD Ach % REF] >= 0.01 && 'Signed Target or MOU'[YTD Ach % REF] < 0.10, "1%~9%",

    'Signed Target or MOU'[YTD Ach % REF] >= 0.10 && 'Signed Target or MOU'[YTD Ach % REF] < 0.20, "10%~19%",

    'Signed Target or MOU'[YTD Ach % REF] >= 0.20 && 'Signed Target or MOU'[YTD Ach % REF] < 0.26, "20%~25%",

    'Signed Target or MOU'[YTD Ach % REF] >= 0.26 && 'Signed Target or MOU'[YTD Ach % REF] < 0.41, "26%~40%",

    'Signed Target or MOU'[YTD Ach % REF] >= 0.41 && 'Signed Target or MOU'[YTD Ach % REF] < 0.51, "41%~50%",

    'Signed Target or MOU'[YTD Ach % REF] >= 0.51 && 'Signed Target or MOU'[YTD Ach % REF] < 0.76, "51%~75%",

    'Signed Target or MOU'[YTD Ach % REF] >= 0.76 && 'Signed Target or MOU'[YTD Ach % REF] < 0.86, "76%~85%",

    'Signed Target or MOU'[YTD Ach % REF] >= 0.86 && 'Signed Target or MOU'[YTD Ach % REF] < 1, "86%~99%",

    'Signed Target or MOU'[YTD Ach % REF] >= 1, "100% Above",

    "Unknown"

)

Above measure slabs are using in Matrix Row as a slaing:

"1%~9%"

"10%~19%"

"20%~25%"

"26%~40%"

"41%~50%"

"51%~75%"

"76%~85%"

"86%~99%"

"100% Above"

and these slab are uing in analysis,  you can check above my pic no. 1.