Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
123abc
Community Champion
Community Champion

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

 

 

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

2 REPLIES 2
SachinNandanwar
Super User
Super User

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



Regards,
Sachin
Check out my Blog

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.