Forum Discussion

POSPOS's avatar
POSPOS
Icon for Post Partisan rankPost Partisan
1 year ago

Measure value not calculating correctly in Power BI Service

Hi All,

I have a measure calculated as below which is used in matrix visual:

Population=
VAR a= SUMX(SUMMARIZE('Table', 'Table'[ID], "f1", CALCULATE(MAX('Table'[dep_emp]))),[dep_emp])
RETURN
 CALCULATE(IF(ISBLANK(a), 0, a))

 

The dep_emp used in the above measure calculation is a calulcated column-

dep_emp = 
IF('Table'[Employee ID] = "#", 'Table'[Position FTE], 'Table'[Employee FTE]/100)

 

The output from desktop is correct as showing below in matrix visual using the measure 'population'.

 

But on Power BI service, the numbers are not showing as expected. They are getting multiplied.

 

Can someone please advise on why this is happening?

Thank you

 

 

Need Help

3 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    1 year ago

    What are the values if you've just published the report from Desktop?

    • POSPOS's avatar
      POSPOS
      Icon for Post Partisan rankPost Partisan
      1 year ago

      danextian  - Below is what I see on service:
      The values change when refreshed on service. But the values remains same on desktop

       

      • danextian's avatar
        danextian
        Icon for Super User rankSuper User
        1 year ago

        What I mean is doe the values change when you've just published from Desktop and viewing the just published report in the service? If it doesn't and then values change only if refreshed in the service, I would download the pbix and inspect the underlying data/tables behind those numbers.