Customer wise totals are not showing correct

[ansar]

Dears,

Need your support to correct the DAX in Image 2 (Measure [PlanLatestDocAmt]) to get customer wise (Cr. Name Column), in that visual Agrmnt column totals are comming properly where as the subtotal showing under each customer is wrong. Ideally the customer wise total is sum of all Agrmnt under that particular customer. 

Measure [PlanLatestDocAmt] : - What am trying to achive under this measure is , find the latest transaction of each Agrmnt column and bring the LC Amt column value in to visualizaition by Customer (Cr. Name) & by Agrmnt. 

Latest transaction means , last transaction date & lates document number.

Sellout Plan =

CALCULATE(

    SUM(GLData[       LC amnt]),

    GLData[Assignment] = "ZMN1" && GLData[PK] = 40)

PlanLatestDocAmt =

VAR MxDt =

    CALCULATE(

        MAX('GLData'[Pstng Date]),

        GLData[Assignment] = "ZMN1" && GLData[PK] = 40

    )

VAR MxDoc =

    CALCULATE(

        MAX('GLData'[Document Number]),

        GLData[Assignment] = "ZMN1" && GLData[PK] = 40

    )

RETURN

    CALCULATE([Sellout Plan],

            GLData[Pstng Date] = MxDt &&

            GLData[Document Number] = MxDoc

       )

Image 1 : -

Image 2 : - 

Regards,

Ansar.

[ansar]

Thanks you so much @Anonymous  really appreciated, it works well

[Anonymous · Accepted solution]

Hi @ansar ,

You can create another new measure as below and put it on the matrix to replace the original measure [PlanLatestDocAmt]:

New Measure= SUMX ( VALUES ( 'GLData'[Document Number] ), [PlanLatestDocAmt] )

If the above one can't help you, please provide some raw data in your table (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards