topic Colum Calculated Measure fine work on BI Desktop but not on published report in DAX Commands and Tips

Colum Calculated Measure fine work on BI Desktop but not on published report

123abc — Thu, 08 Aug 2024 10:23:30 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: Colum Calculated Measure fine work on BI Desktop but not on published report

SachinNandanwar — Thu, 08 Aug 2024 10:06:18 GMT

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

Re: Colum Calculated Measure fine work on BI Desktop but not on published report

123abc — Thu, 08 Aug 2024 10:15:38 GMT

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.