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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

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
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors