Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX , filter out Subset

 

This gets me 90% there

 

CALCULATE(SUM(VW_RPT_PortfolioReview_6Month[CurrentBalance]),ALLEXCEPT(VW_RPT_PortfolioReview_6Month,VW_RPT_PortfolioReview_6Month[POOL],VW_RPT_PortfolioReview_6Month[BalanceDate]))

 

I also want to also filter out 

VW_RPT_PortfolioReview[CATEGORY1]<>"Closed Full Redemption" &&

VW_RPT_PortfolioReview[CATEGORY1]<>"Closed with remaining shortfall"

 

I Tired with = and <> , does not filter out/Add  the "Closed with remaining shortfall"

 

CALCULATE(SUM(VW_RPT_PortfolioReview_6Month[CurrentBalance]),ALLEXCEPT(VW_RPT_PortfolioReview_6Month,VW_RPT_PortfolioReview_6Month[POOL],VW_RPT_PortfolioReview_6Month[BalanceDate]),VW_RPT_PortfolioReview[CATEGORY1]<>"Closed with remaining shortfall")

 

What am I doing wrong ?

 

Need Help

4 Replies

  • themistoklis's avatar
    themistoklis
    Community Champion
    7 years ago

    Anonymous

     

    Can you try the following:

    CALCULATE(SUM(VW_RPT_PortfolioReview_6Month[CurrentBalance]),
FILTER( 
	ALLEXCEPT(VW_RPT_PortfolioReview_6Month,VW_RPT_PortfolioReview_6Month[POOL],VW_RPT_PortfolioReview_6Month[BalanceDate]), 
    VW_RPT_PortfolioReview[CATEGORY1]<>"Closed with remaining shortfall" 
		)
	)
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      Thanks! Knew I was doing something stupid Just missing the FILTER!
      • themistoklis's avatar
        themistoklis
        Community Champion
        7 years ago

        Anonymous

         

        If you are happy with the solution you can mark it as the correct one