Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Lazurens
Frequent Visitor

Divide retruns incorrect result

Hello, 

I have a problem getting the correct division result of this example

Correct Result : DIVIDE(203040543.9, 9830033.751) = 20.66 
When I try the divide operation by itself with these numbers I get 20.66, but when I use the variables I get incorrect result (0.19) ! 
Here is the formulae 
Productivity = 

VAR T1 = SUMX('FACT_PRODUCT_MANUFACTURING', 'FACT_PRODUCT_MANUFACTURING'[TOTAL_QTY] * 'FACT_PRODUCT_MANUFACTURING'[CONVERSION_FACTOR])
VAR T2 = DIVIDE(SUMX('FACT_PRODUCT_MANUFACTURING', 'FACT_PRODUCT_MANUFACTURING'[OPENING_TIME]), 3600)
VAR T3 = SUMX('FACT_PRODUCT_MANUFACTURING', 'FACT_PRODUCT_MANUFACTURING'[REAL_WORK_FORCE])
VAR T4 = DIVIDE(T1, T2 * T3)

RETURN T4

The visualisation will be listed in year_month and the calendar is connected with a cardinality of 1 to many filtering on the Fact table.
Any help will be appreciated, and many thanks in advance.
Regards,

1 ACCEPTED SOLUTION
Lazurens
Frequent Visitor

I somehow made it work this way : 

Productivity = 
VAR T1 =
    CALCULATE (
        SUMX (
            'FACT_PRODUCT_MANUFACTURING',
            'FACT_PRODUCT_MANUFACTURING'[TOTAL_QTY] * 'FACT_PRODUCT_MANUFACTURING'[CONVERSION_FACTOR]
        )
            / SUMX (
                'FACT_PRODUCT_MANUFACTURING',
                ( 'FACT_PRODUCT_MANUFACTURING'[OPENING_TIME] / 3600 ) * 'FACT_PRODUCT_MANUFACTURING'[REAL_WORK_FORCE]
            )
    )
RETURN
    T1

View solution in original post

1 REPLY 1
Lazurens
Frequent Visitor

I somehow made it work this way : 

Productivity = 
VAR T1 =
    CALCULATE (
        SUMX (
            'FACT_PRODUCT_MANUFACTURING',
            'FACT_PRODUCT_MANUFACTURING'[TOTAL_QTY] * 'FACT_PRODUCT_MANUFACTURING'[CONVERSION_FACTOR]
        )
            / SUMX (
                'FACT_PRODUCT_MANUFACTURING',
                ( 'FACT_PRODUCT_MANUFACTURING'[OPENING_TIME] / 3600 ) * 'FACT_PRODUCT_MANUFACTURING'[REAL_WORK_FORCE]
            )
    )
RETURN
    T1

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.