Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi is it posible to sum 2 columns from 14 in matrix view as a extra column in the same view.
This is list of person nad summary work time for certain topics i need in this matrix extra sum of time spend on 2 topix together.
I want to add 1 extra column to this matrix with number 15 and the valu for this column will be sum of col 3 and 4.
Solved! Go to Solution.
It's possible but not simple. The problem is that you currently have one measure (llosc_dni) computed against two dimensions (Nazwisko_imie and Title) but you want to add a new measure that acts as an extra Title dimension value. Measures get evaluated in the context generated by the dimensions you put on the rows and columns, which is why if you add a new measure, it shows up under each number 1-14.
To do what you want, there are two approaches I can think of:
Here's an example of the second approach for a similar but more complex situation:
https://stackoverflow.com/questions/52632713/custom-aggregate-column-in-power-bi-matrix
It's possible but not simple. The problem is that you currently have one measure (llosc_dni) computed against two dimensions (Nazwisko_imie and Title) but you want to add a new measure that acts as an extra Title dimension value. Measures get evaluated in the context generated by the dimensions you put on the rows and columns, which is why if you add a new measure, it shows up under each number 1-14.
To do what you want, there are two approaches I can think of:
Here's an example of the second approach for a similar but more complex situation:
https://stackoverflow.com/questions/52632713/custom-aggregate-column-in-power-bi-matrix
Thank you very much. You saved me.
How did you manage to get it right?
@Anonymous Kindly share the Column name you want to add? Or simply share the screen shot like below:
@Anonymous Try this:
= Calculate(SUM(Ilosc_dni),Title IN {3,4})
OR
= CALCULATE(SUM(Ilosc_dni), Title=3 || Title =4)
Sry for this question but i dont know where to add this.
Do i hav to create a new measure and insert it to columns or hav to make some code editing but dont know where.
@Anonymous Just create a new Measure with that given code.
MEASURE= CALCULATE(SUM(Ilosc_dni), Title=3 || Title =4)
Ok i create it like this
Do i hav to make separate measure for every column i want and then add one by one to Values?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
80 | |
65 | |
52 | |
49 |
User | Count |
---|---|
212 | |
89 | |
79 | |
68 | |
60 |