Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Group by in Dax

  SQL Select BalanceDAte, Sum(CurrentBalance) FROM [dbo].[VW_RPT_PortfolioReview_6Month] Where Pool ='Java' AND CATEGORY1 not in ( 'Closed Full Redemption','Closed with remaining shortfall' ) ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago
    Figured it out CALCULATE(SUMX(FILTER(VW_RPT_PortfolioReview_6Month,VW_RPT_PortfolioReview_6Month[CATEGORY1] <>"Closed with remaining shortfall" && VW_RPT_PortfolioReview_6Month[CATEGORY1]<>"Closed Full Redemption" ), VW_RPT_PortfolioReview_6Month[CurrentBalance]),ALLEXCEPT(VW_RPT_PortfolioReview_6Month,VW_RPT_PortfolioReview_6Month[POOL],VW_RPT_PortfolioReview_6Month[BalDateMonthName]))
Anonymous's avatar
Anonymous
Not applicable
7 years ago
Figured it out CALCULATE(SUMX(FILTER(VW_RPT_PortfolioReview_6Month,VW_RPT_PortfolioReview_6Month[CATEGORY1] <>"Closed with remaining shortfall" && VW_RPT_PortfolioReview_6Month[CATEGORY1]<>"Closed Full Redemption" ), VW_RPT_PortfolioReview_6Month[CurrentBalance]),ALLEXCEPT(VW_RPT_PortfolioReview_6Month,VW_RPT_PortfolioReview_6Month[POOL],VW_RPT_PortfolioReview_6Month[BalDateMonthName]))