Creating a measure which sums based of a conidtion of another

[abcttt233]

I want to create a measure which sums another measure called " sum of total amount" where a measure "TotalTech" is <> 0 then divides this result by TotalTech. This is done in excel with a SUMIF. I have this, which works, but is very slow. Is there a faster way?

Agg =

VAR TotalAmount =

    SUMX(

        abc,

        IF([TotalTech] <> 0,[Sum of TotalAmount],0)

    )

RETURN

    DIVIDE(TotalEPI, [TotalAmount], 0)

[Anonymous · Accepted solution]

Hi @abcttt233 

Maybe you can try the following DAX:

Agg = 
VAR TotalAmount = CALCULATE(
    [Sum of TotalAmount],
    FILTER(
        abc,
        [TotalTech] <> 0
    )
)
RETURN DIVIDE(TotalAmount, [TotalTech], 0)

Also, ensure your data model is as streamlined as possible. This includes removing unnecessary columns, creating appropriate indexes, and ensuring relationships are correctly defined.

Best Regards,

Jayleny

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