how to convert this equation from excel to power bi ?

Question

SUM(SUMIFS($I$22:$I$1048576,$Q$22:$Q$1048576,{"1.1","1.9","1.17"},A$22:A$1048576,A3))/1000

Answer 1

DIVIDE(
    SUMX(
        FILTER(
            TableName,
            TableName[AColumn] IN {"1.1", "1.9", "1.17"}
                && TableName[BColumn] = A3
        ),
        TableName[CColumn]
    ),
    1000
)

Replace "TableName" with the actual name of the table in your data model.

Also, replace "AColumn," "BColumn," and "CColumn" with the corresponding column names in your table.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.