SumProduct with Power BI

Hi Sandeep_PowerBI ,

In Power BI, you need to use unpivot and pivot for your data first, and then you can perform calculations.

After transformation, the data is as follows.

Create this measure:

Measure =
VAR _table =
    SUMMARIZE (
        'Table',
        [Line],
        [ABC],
        [HMP],
        "Product", SUM ( 'Table'[ABC] ) * SUM ( 'Table'[HMP] )
    )
RETURN
    DIVIDE (
        SUMX ( _table, [Product] ),
        SUMX ( FILTER ( ALL ( 'Table' ), [Line] = MAX ( 'Table'[Line] ) ), [HMP] )
    )

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.