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.
Hi
I am wanting to write a measure that gives me the percentage of grand total (of a row item), issue is that this is using other measures to calculate.
What I'm trying to do is check how much each department is spending of budget per month from their total budget spend.
Ideally I want to get the columns measure grand total and then divide each department's spend by it.
The "spend" is currently a measure, so it seems I can't use:
Measure = CALCULATE(SUM('Table1'[Spend])
How would I go about returning the total sum of a measure (e.g., the total spend of the departments)?
Hi @Morkil,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
For some reason it returns 100% for every row. Not sure why but it's calculating at the row level, not the column level.
I've tried SUMX - does the same thing row level.
Sum doesn't work at all. Must be some restrictions to my database connection? (is live)
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |