Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

CALCULATE ALL filter Open Amount

Hi All,

 

The Open Amount column is a dax measure: 

Open Amount = SUM(Fact_CustLedgerEntryDetailed[Amount]))
 
Using this measure it returns the following table:
 
I need to somehow to change the Open Amount formule in order to return the following table result:
 
PostingDateDocumentNumberDescriptionAmountDocumentTypeOpen Amount
Wednesday, 31 December 2014GVFK-143979Order VOR-1436078,061.302200

 

 

Any suggestions? Many thanks.

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

4 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    6 years ago

    You can try: 

     

    Open Amount = CALCULATE(SUM(Fact_CustLedgerEntryDetailed[Amount])), ALL(Fact_CustLedgerEntryDetailed[Document Number]))

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi AllisonKennedy ,

       

      Thanks for reply but i still dont have the expected result.

       

      For your information this table is also filtered by the slicer object " CustLedger Entry OpenAmount" with value 1. This slicer is based on column OpenAmount from the CustLedgerEntry table.

       

      The visual table contains columns from CustLedgerEntryDetailed table.

       

       

      • AllisonKennedy's avatar
        AllisonKennedy
        Icon for Community Champion rankCommunity Champion
        6 years ago

        You actually probably need more in the ALL, you just need to consider what filters you want to remove and keep: 

         

        Open Amount = CALCULATE(SUM(Fact_CustLedgerEntryDetailed[Amount])), ALL(Fact_CustLedgerEntryDetailed, [Document Number], [Document Type]))

         

        You'll need to fix syntax in the above and add table names.