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

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

Import Pics:

Desktop report matrix show YTD salesPublished report not showing YTD SalesSales Table and Signed Target or MOU Table relationshipCalculated Column Measure in Singed Target or MOU Table

[Anonymous]

Hi, @123abc 

I am glad to help you.

I downloaded and published the pbix file you provided into different types of workspaces in Power BI Service. After my testing, all the values of report are displayed properly in my Power BI Service:
Trial workspace:

Power BI Pro workspace:

Premium Per User workspace:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[123abc]

First of All Very Thank You Very Much for you great support.

I am Pro User, when i published this report after few minuts data is disappeared... sales table is coming from Oracle ERP and my singed target table is coming with an excel file from share point ... gate-way is properly configured bcz there are many other analytics are working properly and no issue ....  can you guide what possibilities are there. 

[Anonymous]

Hi, @123abc 

Perhaps you could clear your browser's cache, and then you could recreate a new workspace and publish the report to the new workspace and check if the issue still occurs.

Or you can publish the report to another member's workspace in your organization to see if the report displays correctly and if the gateway is working correctly.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AnkitKukreja]

Hi @123abc 

Can you check your visual does not ahve any filters in service? Try to republish the report to my workspace or any different workspace.

I am taking part in the Fabric sticker challenge, please vote for me, and share across your team team please.

https://community.fabric.microsoft.com/t5/Fabric-Community-Sticker-Design/Wishing-health-to-all-the-...

https://community.fabric.microsoft.com/t5/Fabric-Community-Sticker-Design/A-Fabric-Community-Super-U...

https://community.fabric.microsoft.com/t5/Fabric-Community-Sticker-Design/Superman-Oh-I-meant-Super-...

https://community.fabric.microsoft.com/t5/Fabric-Community-Sticker-Design/Data-is-everywhere/cns-p/4...

https://community.fabric.microsoft.com/t5/Fabric-Community-Sticker-Design/Client-I-need-a-tool-that-...

[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 Slab analysis:

"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.

[123abc]

no filter on visual or no on service.