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[B...
Need Help
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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      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.