Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
9 |
User | Count |
---|---|
28 | |
23 | |
12 | |
11 | |
10 |