DAX , filter out Subset

[Anonymous]

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 ?

[themistoklis]

@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]

Thanks! Knew I was doing something stupid Just missing the FILTER!

[themistoklis]

@Anonymous

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

[Anonymous]

I keep getting an error , tried IE too; think IT in here have javascript disabled Authentication failed for the action you are trying to do. This failure could be due to your browser not supporting JavaScript, JavaScript not being enabled, or trying to use the action URL directly in the browser address bar instead of clicking the link on the page.