Need help in optimizing Calculate divide with Filter function

[rishari]

Please help me to optimize the below measure. The visual is not even loading for the current measure

DAX Measure:

X_Percentage =
CALCULATE (

    DIVIDE ( Measure_A, Measure_B, 0),
    FILTER ( 'TableName', Calculated_column > 0 )
)

[Anonymous]

Hi @rishari ,

Please try below dax formula:

X_Percentage =
CALCULATE (
    DIVIDE ( Measure_A, Measure_B, 0 ),
    FILTER ( ALL ( 'TableName' ), Calculated_column > 0 )
)

If it also not work, please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[johnt75]

Its better not to filter an entire table when you can just filter a column. Try

X_Percentage =
CALCULATE (
    DIVIDE ( Measure_A, Measure_B, 0 ),
    'TableName'[Calculated_column] > 0
)

[rishari]

It was not working, that's why i used filter function