Forum Discussion

cottrera's avatar
cottrera
Post Prodigy
2 years ago
Solved

DAX Ignore filter context

Hi I have the following table UPRN High or Low MPV_ NPV Net Rent_ 18 High £122,768.31 26 High £109,681.07 92 High £116,317.17 109 High £81,850.06 117 High £119,385.69 ...
Need Help
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    Hi cottrera ,

     

    The ALL function can remove any filter context. You can try below measure:

     

    Avg NPV_ = 
CALCULATE(
    VAR NetRentNPV = SUM('NPV Table_'[NPV Net Rent_])
    VAR Prop = COUNTROWS('NPV Table_')
    VAR AvgNPV = DIVIDE(NetRentNPV, Prop)
    RETURN
    AvgNPV,
    ALL()
)

     

    Please mark this as solution and give Kudos, if this helps resolve your issue.

     

    Thank you~

PurpleGate's avatar
PurpleGate
Resolver III
2 years ago

try

 

AvgNPV_No filters = calculate[Avg NPV_], removefilters('Table UPRN'))

 or

AvgNPV_All = calculate[Avg NPV_], ALL('Table UPRN'))

 

whatever table has that first column in

cottrera's avatar
cottrera
Post Prodigy
2 years ago

Thank you also for contributing