Forum Discussion

skasper's avatar
skasper
Responsive Resident
9 years ago

Web Service and Desktop Client show different Result for same Measure

Hi,

 

I am facing a strange situation:

  • I created a PowerBI report using the Desktop Client
  • The data is coming from an Excel file on SharePoint
  • In the report I calculate a measure called RPE
  • The value for the same measure is different in the desktop client vs. the web service (see below)

Web ServiceDesktop Client

 

What I did (in that order):

 

  1. Refresh data in the web service
  2. Refresh data in the client
  3. Refresh preview data in the client
  4. Refresh data in the client again
    --> all to no avail
  5. Publish the refreshed report from the client to the web (replacing the Dataset)
    --> no change
  6. Delete the dataset, report and dashboard from the web service
  7. Publish the refreshed report from the client to the web
    --> same problem

Any ideas, how it can show different values for the same data and calculation and - more importantly - how to fix it?

 

Thank you.

Need Help

8 Replies

    • skasper's avatar
      skasper
      Responsive Resident
      9 years ago

      Hi Simon,

      Act. RPE 2016 = [Act. Revenue]/[Employees 2016]

      With

      Act. Revenue = 
CALCULATE(
	SUM('All Years'[Value]);
	FILTER(tbl_categories;tbl_categories[Label]="Revenue");
	'All Years'[Type]="Actual"
)

      And the number of employees based on an on-premise CRM. Counting only those, who have a contract start date before 2017 and a contract end date after 2016 (or none). 

      Employees 2016 =
CALCULATE (
    COUNTA ( alm_employee[ID Employee] );
    FILTER (
        alm_employee;
        alm_employee[Contract Start].[Date] < DATEVALUE ( "01/01/17" )
    );
    FILTER (
        alm_employee;
        OR (
            alm_employee[Contract End].[Date] > DATEVALUE ( "31/12/16" );
            alm_employee[Contract End].[Date] = 0
        )
    )
)

      Hope this helps. Thank you.

       

       

      • skasper's avatar
        skasper
        Responsive Resident
        9 years ago

        Hi v-sihou-msft,

         

        I now double checked the results manually. The numbers in the client are correct. There are also no additional/other filters set on the web service.

         

        Also, if the formula were wrong, I should get wrong - but identical - results in both, the web service and the desktop client.

         

        However, the source data and calculation are completely identical and still the result in the web service remains wrong.