Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello to everyone,
I would like to obtain some calculation on PowerBI
I created a matrix with 3 data columns (RE, RI, CE) and I would like to have a new column with a calculation (RI+(RE-CE))
How can I do?
Thank you in advance
Solved! Go to Solution.
Hi @olofu,
Did these values analyze from attribute, value columns(attribute to matrix column field, value to matrix value field), or three value columns?
If you mean the first one, you need to calculate based on the Aree group and filter conditions:
Result =
CALCULATE (
CALCULATE ( SUM ( Table[Value] ), [Type] = "RI" )
+ CALCULATE ( SUM ( Table[Value] ), [Type] = "RE" )
- CALCULATE ( SUM ( Table[Value] ), [Type] = "CE" ),
FILTER ( Table, [Area] = EARLIER ( Table[Area] ) )
)
If you mean the second one, you can directly create a calculated column to invoke these value fields to calculate:
Result =
Table[RI] + Table[RE] - Table[CE]
Regards,
Xiaoxin Sheng
Hi @olofu,
Did these values analyze from attribute, value columns(attribute to matrix column field, value to matrix value field), or three value columns?
If you mean the first one, you need to calculate based on the Aree group and filter conditions:
Result =
CALCULATE (
CALCULATE ( SUM ( Table[Value] ), [Type] = "RI" )
+ CALCULATE ( SUM ( Table[Value] ), [Type] = "RE" )
- CALCULATE ( SUM ( Table[Value] ), [Type] = "CE" ),
FILTER ( Table, [Area] = EARLIER ( Table[Area] ) )
)
If you mean the second one, you can directly create a calculated column to invoke these value fields to calculate:
Result =
Table[RI] + Table[RE] - Table[CE]
Regards,
Xiaoxin Sheng
@olofu
I would suggest you to do it using Calculation Groups in Tabular Editor:
Please refer to this article on how to do it: https://blog.enterprisedna.co/matrix-in-power-bi-using-calculation-groups/
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
186 | |
93 | |
67 | |
63 | |
54 |