Forum Discussion
Advocate IDAX Formula Showing Blank
MaxIndex was not getting calculated correctly, so we calculate maxindex of the account you are inerested, same I did for other DAX
Var BankAcct1 = "1008 · Chase Checking"
Var MaxIndex =
CALCULATE(MAX('Sanitized Transaction Detail v2'[Index]),
'Sanitized Transaction Detail v2'[Account] = BankAcct1 )
Advocate IDaniel, thanks for the reply.
I may be missing how your proposed response will work.
It doesn't seem like filtering out the blanks will work. My measure for BankAcct1 Balance should already be filtering out the blanks of the balance column which is the column that I am trying to retrieve. When I filter the table down to the correct Bank Acct (1008 · Chase Checking) and the max index, there should only be one row remaining and the balance column should be non-blank.
If you are able to access the pbix file and excel file I attached, it may help. What is very strange is if I delete the last two rows in the source table, the BankAcct1 Balance measure start working correctly. It is no longer blank. But the BankAcct2 Balance measure is still showing blank. I'm seriously stumped.
Ideas?
Super UserMPRIf I undetstood your requirement correctly, you are looking to get the max balance of each account based on maximum index number of the account, correct?
- parry2k
I guess this the output you are looking for
- MPR
parry2kThat is exactly what I need. How did you do that? And what was wrong with my measure?
Thanks in advance.
MPR
- parry2k
MaxIndex was not getting calculated correctly, so we calculate maxindex of the account you are inerested, same I did for other DAX
Var BankAcct1 = "1008 · Chase Checking"
Var MaxIndex =
CALCULATE(MAX('Sanitized Transaction Detail v2'[Index]),
'Sanitized Transaction Detail v2'[Account] = BankAcct1 )