Forum Discussion

nizaeros's avatar
nizaeros
New Member
4 years ago

Max function showing wrong. Need help for Powerbi Matrix total

Hello everyone, I need your support to solve and understand issues in my DAX. I have a transactionDB of all bank transaction like below:   date company type Source Bank amount 01-Apr-22 ...
matrix calculation
Matrix grouped columns issue
MAX date
v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi nizaeros ,

According to your description, I create a sample the same with yours.

But the Opening balance return nothing when select 2022/6/1-2022/6/3.

Most of your date are from April, I don't know why you select June in the slicer, if your sample data is not complete, please show the data related to the expected result. Then we can reproduce your problem.

Just from the formula, you can try to modify it like this:

Credit =
CALCULATE (
    SUM ( transactionDB[credit] ),
    FILTER (
        ALLSELECTED ( transactionDB[date] ),
        transactionDB[date]
            = MAXX ( ALLSELECTED ( transactionDB[date] ), transactionDB[date] )
    )
)

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.