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 )
Microsoft EmployeeHi MPR,
Based on my test, you can refer to below steps by using filter function:
1.I have create a Table visual and add the related fields like the picture below:
2.Expand the “BankAcct1 Balance” field in the Filters and choose the “is not blank”, apply the filter.
Now you can see the correct result.
Regards,
Daniel He
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?
