Running Total Balance first entry

[bhelou]

Dear ,
kindly help me with this measure  , it is giving the balance correct after the secod entry as shown  then the rest is correct , 

Running_Total_AP_Balance_unique =

CALCULATE (

SUM ( Accounts_Payable[Balance] ),

FILTER (

ALLSELECTED ( Accounts_Payable ),

Accounts_Payable[Rank_By_Vendor]

<= MAX ( Accounts_Payable[Rank_By_Vendor] )

)

)

// i think it is from the duplicate rank from vendor , it is based in  this measure

Rank_By_Vendor =

VAR __table =

FILTER (

ALL ( 'Test' ),

[Date]

< EARLIER ( Accounts_Payable[Date] )

&& ( [Vendor_Number] )

= EARLIER ( Accounts_Payable[Vendor_Number] )

)

VAR __tableSame =

FILTER (

ALL ( 'Test' ),

[Date]

= EARLIER ( Accounts_Payable[Date] )

&& [TRANSACTION_LINE_UNIQUE]

< EARLIER ( Accounts_Payable[Transaction_ID_Unique] )

&& [Vendor_Number]

= EARLIER ( Accounts_Payable[Vendor_Number] )

)

RETURN

COUNTROWS ( __table ) + 1

+ COUNTROWS ( __tableSame )



Many Thanks for your usual help>

[bhelou]

Solved , 
measure as follow :

Rank_By_Vendor =

VAR __table =

FILTER (

ALL ( 'Accounts_Payable'),

[Date]

< EARLIER ( Accounts_Payable[Date] )

&& ( [Vendor_Number] )

= EARLIER ( Accounts_Payable[Vendor_Number] )

)

VAR __tableSame =

FILTER (

ALL ( 'Accounts_Payable' ),

[Date]

= EARLIER ( Accounts_Payable[Date] )

&& Accounts_Payable[Transaction_ID_Unique]

< EARLIER ( Accounts_Payable[Transaction_ID_Unique] )

&& [Vendor_Number]

= EARLIER ( Accounts_Payable[Vendor_Number] )

)

RETURN

COUNTROWS ( __table ) + 1

+ COUNTROWS ( __tableSame )

[parry2k · Accepted solution]

@bhelou it will be easier to answer if you post a sample data and expected output. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490