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.
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
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |