Simple.....?...DAX Question

Question

Hello,I am publishing a paginated report connecting to Power BI dataset. The dataset looks like this:&nbsp;&nbsp;Transactions are recorded for March, Feb, and Jan 2021 and the requirements are next.&nbsp;&nbsp;&nbsp;The first requirement is to get the current month's balance for all accounts that are not 55500 nor 888000.The second requirement is that for the account 55500 the balance is the current YTD.&nbsp;The third requirement is to get the balance of the all other accounts times -1 to balance zero when all balances are added.#1 and #2 are straightforward,&nbsp;&nbsp;EVALUATESUMMARIZECOLUMNS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; group6, group7, group8, group9,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dept, subdept, account,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"TotBal", CALCULATE(SUM('table'[tranval]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'table'[account]&lt;&gt;"55500" &amp;&amp; 'table'[account]&lt;&gt;"88800"),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;"Tot55500", CALCULATE(SUM('table'[tranval])),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER(VALUES('table'[tranval]),'table'[account]="55500"),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER(VALUES( 'table'[trandate]), YEAR('table'[trandate]) = YEAR(datevalue("3/1/2021")))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;)&nbsp;&nbsp;#3 just cannot figure it out. How to get AdjBal?&nbsp;As you can see, the balance for account 88800 should be the value to zero out the aggregation of all other balances (440-75+50) = 220 * (-1) = -415&nbsp;Any ideas are greatly appreciated.&nbsp;Thanks,Antonio&nbsp;&nbsp;&nbsp;

v-xiaotang · Answer

Hi&nbsp;jagus&nbsp;
it's impossible to continue generating the column&nbsp;AdjBal&nbsp;in that function. so we can only recreate the column&nbsp;AdjBal&nbsp; later.
for example,

ORcould you share your sample data or sample file after removing sensitive information? so that we can work on it further.
Any question, please let me know.
&nbsp;
&nbsp;
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

v-xiaotang · Answer

Hi&nbsp;jagus&nbsp;
Have you solved your problem? If yes, kindly accept the answer helpful as the solution(OR kindly share your solution😁). so the others can find it more quickly.
Or
if problem still persists, please let me know.
&nbsp;
&nbsp;
Best Regards,
Community Support Team _ Tang

Forum Discussion

Simple.....?...DAX Question

2 Replies

Related content

Simple question on DAX

Simple DAX Query Question

Bookmark questions

Simple DAX question

Create simple DAX Measure