Excluding that specific row amount from total amount from every single row calculation
Hello Group, I have an issue where I need to calculate overall profitability impact if I exclude that single product and in Excel it was easy but I need it as a visual in Power BI? In below screen shot, I need help on DAX on columns highlighted where In if Product A Net revenue is excluded from Total Revenue what would be my impact on overall profitability. Now I need that for each single row calculation where Prod B,C,D etc excluded and calculate its Impact? Please help on DAX calcualtion in regards to it?DAX subtotals P&L reporting Direct Query
Hello everyone, I am making a P&L in Power BI with a direct query connection with SAP data and a hierarchy from SAP. The situation is that the SAP hierarchy could not be changed. I want to format the hierarchy with some small changes. How do i fix this at the best way? Is it possible with DAX? In the attachment i have provided a p&L file and some example data. Revenue is a positive number and costs are negative. This two minus each other is the subtotal of the EBITDA. What i want to create is the following: GL_account_level 3 Revenue Gl_account_level 4 Revenue Revenue cars GL_account_level 3 Costs Gl_Account_level 4 Cost Loan costs EBITDA (subtotal) GL_account_level 3 Depreciation Gl_account_level 4 Depreciation Depreciation cars EBIT (subtotal) GL_account_level 3 Interest (Regular exploitationresult subtotal) GL_account_level_3 Extraordinary income and charge Subtotal result before tax The current situation is the following: EBIT (level 1) EBITDA (level 2) Revenue (level 3) Revenue cars (level 4) Costs (level 3) Loan costs (level 4) Interest and depreciation (level 2) Extraordinary income and charge (level 1) Extraordinary income and charge (level 2) Extraordinary income and charge (level 3) Total Power BI result before tax I am searching very long for a good way how to fix this, so if anyone can help me i'm very happy:)Simple Cost Ratio from GL Data
Hello all, pretty frustrated with what I feel should be a simple task I have a simple set of GL data, as seen below, where my amount is in one column, and my accounts are rows. I then do a very simple model where I have a GL Account class lookup table, which assigns the class "revenue" and "cost" to each account. I then just want to have a simple cost ratio at the account level, of cost/total revenue. the table should look as such below, but nothing returns at the account level for a margin. even the revenue accounts are wrong, as Revenue Reg should be 60% of total revenue, , and Revenue Spec should be 40% My measures are Value = SUM(data_table[Amount]) Total Revenue = CALCULATE([Value],gl_class[Class]="Revenue") Cost Margin = DIVIDE([Value],[Total Revenue]) any help would be greatly appreciated
