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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Regular Visitor

How to calculate Sales/OPEX/... % from general ledger

Hello everyone!


I am trying to calculate certain percentages like sales percentage, opex percentage and visualize it on PBI. I know that I have to make some new measures like 'Total Revenue', 'Total OPEX' and then divide it by a grand total, but the problem is that I have these data all in one table (the general ledger). I don't know how I can compute the total for one specific account number (let's say the 70-account, which represents the sales revenue), because the data is not seperated in different tables.


(So, to give you guys a bit more context, the general ledger table consists of all the account numbers that are present in the company and represents all the movements in these account numbers. There is also always an amount connected with a line in the table. For example, when there is an sales invoice, this invoice is one specific line in the table.)


Do you guys know how I can do this?


Many thanks in advance!



Resolver II
Resolver II

Hi @DM0010 ,


You should use the CALCULATE if you have the account column, for example


Total_Revenue =


 SUM ( [Amount]),

 FILTER ( 'Table', LEFT ( [Account_column], 2) = "70")




Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors