Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Need your help in solving why the added measure is working in PowerBI Desktop just fine, but after publishing the report to PowerBI Service, the same measure does not work anymore.
Here's an example of data from the report.
Date | Date created | Print# | PASS_FAIL |
Wednesday, 22 July 2020 | 22/07/2020 14.34.48 | 20203003 | 0 |
Tuesday, 21 July 2020 | 21/07/2020 14.55.10 | 20202008 | 0 |
Wednesday, 22 July 2020 | 22/07/2020 14.55.20 | 20203010 | 0 |
Wednesday, 22 July 2020 | 22/07/2020 14.38.22 | 20203004 | 0 |
Wednesday, 22 July 2020 | 22/07/2020 14.56.54 | 20203011 | 0 |
Wednesday, 22 July 2020 | 22/07/2020 14.53.44 | 20203009 | 0 |
Wednesday, 22 July 2020 | 22/07/2020 14.50.49 | 20203008 | 0 |
Wednesday, 22 July 2020 | 22/07/2020 14.47.33 | 20203007 | 0 |
Wednesday, 22 July 2020 | 22/07/2020 14.44.48 | 20203006 | 0 |
Wednesday, 22 July 2020 | 22/07/2020 14.42.03 | 20203005 | 0 |
Wednesday, 22 July 2020 | 22/07/2020 14.10.54 | 20203002 | 0 |
Wednesday, 22 July 2020 | 22/07/2020 11.20.46 | 20203001 | 0 |
Tuesday, 21 July 2020 | 21/07/2020 14.53.32 | 20202007 | 1 |
Tuesday, 21 July 2020 | 21/07/2020 14.51.22 | 20202006 | 1 |
Tuesday, 21 July 2020 | 21/07/2020 14.49.45 | 20202005 | 1 |
Tuesday, 21 July 2020 | 21/07/2020 14.38.50 | 20202004 | 0 |
Tuesday, 21 July 2020 | 21/07/2020 14.20.10 | 20202003 | 1 |
Tuesday, 21 July 2020 | 21/07/2020 13.50.47 | 20202002 | 1 |
Tuesday, 21 July 2020 | 21/07/2020 12.50.47 | 20202001 | 1 |
Tuesday, 21 July 2020 | 21/07/2020 9.02.20 | 20201008 | 1 |
Tuesday, 21 July 2020 | 21/07/2020 9.00.52 | 20201007 | 1 |
Tuesday, 21 July 2020 | 21/07/2020 8.58.32 | 20201006 | 0 |
Tuesday, 21 July 2020 | 21/07/2020 8.53.53 | 20201005 | 1 |
passed = SUM(AOISummaryData[PASS_FAIL])
total tested = CALCULATE(DISTINCTCOUNT(AOISummaryData[PlcTrackingID]),AOISummaryData[Print#]<>BLANK())
test yield = IF(DIVIDE(AOISummaryData[passed],AOISummaryData[AOI total tested])=0,0,DIVIDE(AOISummaryData[passed],AOISummaryData[AOI total tested]))
And the measure that is not working is the "passed". As you can see the images from the Desktop and Service screenshots.
I have tried many things already, like removing the dataset from the service, creating the measures again etc. but so far I have not been able to solve this issue.
Thanks in advance!
BR,
Andy
@andy0012 - There may be some saved filter in the Service, you can reset the report in the Service to default (clear personal filters/bookmarks)
Hi Greg_Deckler,
Unfortunately this was not a solution to this issue, did remove any filters in the Service and still the calculated measures won't give correct readings in the Service.
-Andy
Try Remove "Dataset" in Power BI Service if possible and publish report again.
Also make sure that both reports have same filters applied on it.
Proud to be a Super User!
Hi FarhanAhmed,
Thanks for the tip, but these activies I did try already and they did not solve the issue.
-Andy
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |