Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Desktop Matrix fine showing YTD sales
published report matrix not showing YTD Sales
Sales Table and Singed Target or MOU Table relationship
Calculated Column in Singed Target or MOU Table
Have you tried converting one of those calculated columns to a measure ?
i need calculated column not regular measure bcz this calculted column are using furhter column for my analysis like :
"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.
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
8 |
User | Count |
---|---|
31 | |
27 | |
15 | |
13 | |
10 |