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 facing a problem,I have three different columns as column A,B,C. I took a custom column in the custom column, i need first row as Sum of column A, in second row i need sum of column B, in third row i need sum of Column C how to calculate this
Plz help me out
Thanks in advance
you can click "edit queries" in home tab and click "customer column" in add column tab
I need to display a table report with sum of different column as one column
how can i do that
Sorry Aryan,
your requirement is not very clear to me untill you post some sample data of around 10 rows and desired output format.
If you only want the totals of all three columns in just one table .
You can three measures for each of the columns total.
then choose Matrix and drag the three measures in it.
then u can choose Format tab : "Show on rows : on " State.
consider this as my report
Total | |
Sum of customers | 4 |
Sum of Other charges | 120 |
Sum of charges | 360 |
this my table
customers | charges | Other charges | |
1 | 100 | 50 | |
2 | 30 | 10 | |
3 | 100 | 20 | |
4 | 130 | 40 |
from this table i need to develop the above report
Add 3 Measures:
Sum of Other Charges = Sum(Table1[Other charges])
Sum of Customers = DISTINCTCOUNT(Table1[customers])
Sum of charges = Sum(Table1[charges])
The add a Matrix :
Add the three Measures in it.
Go to Format option > Value > Show on Row : On
codes | Total | |
Sum of customers | 2 | 7 |
Sum of Other charges | 3 | 120 |
Sum of charges | 4 | 360 |
i tried using matrix it should look like this
You can achieve this by creating a new table This table will remain island and will not link to any other table in the model.
then in Report View :
U can create a Matrix with dimension as Attribute .
Now create 2 measures :
Sum = if(MAX([Sort])=1,[Sum of Customers],if(MAX([Sort])=2,[Sum of charges],[Sum of Other Charges]))
Count = if(MAX([Sort])=1,DISTINCTCOUNT(Table1[customers]),if(MAX([Sort])=2,DISTINCTCOUNT(Table1[charges]),DISTINCTCOUNT(Table1[Other charges])))
You can edit logic / calculations as per your requirement.
can we enter data in to custom column in power bi like for custom column count
1
2
3
4
5
6
Hi @aryan,
It seems that your initial requirement have been solved. Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
@aryan wrote:
can we enter data in to custom column in power bi like for custom column count
1
2
3
4
5
6
In addition, do you want to create a custom column like above in Query Editor?
If you want to create that column, you could go to Editor Queries——Add Column——Index column.
If you need additional help, please share your desired output.
Best Regards,
Cherry
can we data in to column from edit query like for column count
1
2
3
4
5
6
Hope This helps !!!!
Thank u very much but if want to insert codes in between that 2 columns
you can click the table and add the values which colum data you whant, and select sum
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |