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]))
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi

Very happy to see the issue solved by yourself.

It is very generous of you to share the solution here so that other prople may benefit from this thread.

 

Best Regards

Maggie