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,
Hope you all are doing well
I have a column which includes total revenue and all the other fields e.g total project cost, project indirect cost and others these all are in one column as shown in image below. How can i calculate percentage of all the fields in that column out of total revenue which is also in that column as you can see in image.
alittle help required! Thanks in advance.
Hi,
Does this measure work?
Measure = sum(Data[Total])
Measure 2 = divide([Measure],calculate([Measure],Data[Expense]="Revenue"))
Format Measure 2 as a %.
Hi @WaleedAli
Try this:
percent =
DIVIDE (
SUM ( Table[Value] ),
CALCULATE (
SUM ( Table[Value] ),
FILTER ( ALL ( Table[Expense] ), Table[Expense] = "Total Revenue" )
)//to divide the sum for each item in Expense over Total Revenue
)
Proud to be a Super User!
@danextian Hi, i appreciate your effort.
But it is still not working.
I have carried out total revenue value from column. But when i put that value in DIVIDE function it don't print out all the percentages of the remain field out of total revenue. Alittle help needed thanks.
Hi @WaleedAli ,
What do you mean by the percentages of the remain field out of total revenue?
Also please share a sample data that we can easily manipulate - not an image.
Proud to be a Super User!
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |