Forum Discussion

themistoklis's avatar
themistoklis
Community Champion
8 years ago
Solved

Filter table based on Calculated Measure(s), using DAX formulas

Hello im having a table (object on a sheet) on powerBI which i would like to filter its rows based on certain column(s). This column(s) is a calculate measure. In our case if a value is below a cert...
Need Help
  • themistoklis's avatar
    themistoklis
    8 years ago

    venug20

    Thank you for this partial solution.

    There is one limitation though. The total row still shows data including the outliers.

     

    I found a better filtering which also shows the correct total which is the following one.

    I will add both yours and mine so as to help other readers:

    Yours:

     

    % AVG Effort 2 Cost 2 = IF([% AVG Effort 2 Cost] > 0.40, [% AVG Effort 2 Cost], BLANK())

    Mine:

     

    % AVG Effort 2 Cost 2 = CALCULATE([% AVG Effort 2 Cost];FILTER(Calculated_Measures;[% AVG Effort 2 Cost]>=0.4))

     

    This is a great alternative

     

     

  • themistoklis's avatar
    themistoklis
    Community Champion
    8 years ago

    venug20

    Thank you for this partial solution.

    There is one limitation though. The total row still shows data including the outliers.

     

    I found a better filtering which also shows the correct total which is the following one.

    I will add both yours and mine so as to help other readers:

    Yours:

     

    % AVG Effort 2 Cost 2 = IF([% AVG Effort 2 Cost] > 0.40, [% AVG Effort 2 Cost], BLANK())

    Mine:

     

    % AVG Effort 2 Cost 2 = CALCULATE([% AVG Effort 2 Cost];FILTER(Calculated_Measures;[% AVG Effort 2 Cost]>=0.4))

     

    This is a great alternative