Forum Discussion

rishari's avatar
rishari
Frequent Visitor
3 years ago

Need help in optimizing Calculate divide with Filter function

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 )
)

Need Help

3 Replies

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    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's avatar
      rishari
      Frequent Visitor
      3 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.