Use percentage measure for multiplication

powerbijourney — Tue, 13 Aug 2019 12:24:26 GMT

Hi There,

I have the following DAX that calulates the percentage of the items based on the total

Percentage Of Total Units = DIVIDE(
    [Total Units],
    CALCULATE(
        SUM(table_1[Unit Length]),
        ALLSELECTED(table_1)
    )
)

This works great, and displays percentage per row in a table, however I need to use this percentage per row and multiply this by another value. I tried the following:

Measure = PRODUCTX(
    VALUES(
        table_1[unit_cost/h]
    ), 
    [Percentage Of Total Units]
)

But this does not give me the expected value, its wrong.

Is the percentage measure incorrect? Or am I using the wrong functions?

topic Use percentage measure for multiplication in Developer

Use percentage measure for multiplication