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 (...
Need Help
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