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~

xifeng_L's avatar
xifeng_L
Super User
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~

  • cottrera's avatar
    cottrera
    Post Prodigy
    2 years ago

    Thank you for your quick response