Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
hanygameel
Helper I
Helper I

how can i sum all minus balance for account with account category

i have journal entry that each one has debt and credit and i made balance as measure ,
i made category for each account to categorize balance sheet accounts

i need to make measure to sum all minus balance for all sub account for account receivable

 

hanygameel_0-1677919572748.png

 

 

3 REPLIES 3
hanygameel
Helper I
Helper I

any one can help

hanygameel
Helper I
Helper I

Thanks for you response
but with this approach
i get only credit transaction not balance of sub account

hanygameel_0-1677930543176.png

see above entry sub account has zero balance

below my balance measure

Balance = SUMX('GL_All Branch',[DR_AMOUNT])-SUMX('GL_All Branch',[CR_AMOUNT])
thanks for advance


i this sub account as minus balance
but the 

Ahmedx
Super User
Super User

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.