Forum Discussion
Creating a Sum Measure Conditionally (Revenue vs Another Accounts)
Dear Power BI Experts,
I'm trying to create a New Measure where I have a constant value which is the Revenue. My idea is to find what is the percentage of each accounting cell against the Revenue. I have tried the next formula:
Total Revenue= CALCULATE(sum(ALS[Value]),ALL(Accounting Name)). Besides, I tried with using FILTER, but it took the whole table.
Also, I tried with "SumX".
I will how you how my data is in Excel.
I have the same data for each year in just one column (Accounting Name, Value, Year, Month).
Do you know how can I get just the sum of the total Revenue? Thank you very much.
| Service Revenue | 3.796 |
| Product Revenue | - |
| Reimbursable Revenue | 21 |
| TOTAL REVENUE | 3.817 |
| International Mobile | 50 |
| International Commuters | - |
| Home Country Commuters | - |
| Home Country Mobile | 106 |
| Home Country Resident Exempt | 204 |
| Home Country Resident Non-Exempt | 185 |
| GeoMobile | 4 |
| Contractors | 10 |
| TOTAL COMPENSATION | 560 |
| Materials & Supplies | 249 |
| Depreciation | 335 |
| Multiclient/Horizon Amort | - |
| Product cost | 1 |
| Transportation & Mobilization | 249 |
| Lease & rent | 53 |
| Office & Camp | 29 |
| Travel & Entertainment | 10 |
| Multiclient Capitalization | - |
| Legal and Professional fees | 18 |
| Training costs | 1 |
| Reimbursable costs | 11 |
| Other Expenses | 313 |
| Field Segment Management Cost | 110 |
| SINet | 30 |
| TOTAL FIELD COST | 1.969 |
| FIELD SEGMENT CONTRIBUTION | 1.848 |
14 Replies
sreyes10 if you trying to get the % you need to divide the amount of a specific account into the total
i dont think i imported in the data correctly but look at my %of total measure to show you what i think you trying to do
Hello GvA ,
Thanks for your answer.
I have tried that formula, but in my data I have the same data replicated for all years, this means that the table is constantly repeated. It means that I have a columns with the period for each one.
When I used that formula, It took the whole total Revenue of all periods and not the period that I want.
