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
Icon for Community Champion rankCommunity 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
      Icon for Community Champion rankCommunity 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.