The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All,
I have the following two simple measures.
DIF_M1 L3 = [Sum MFR1 L3]-[Sum Actuals L3]
and
ABS_M1 L3 = Abs( [Sum MFR1 L3] - [Sum Actuals L3] )
and I get the following results
Obviously the the absolute values are calculated in the fisrt column. However the Total of the first column (ABS_M1 L3) is not the sum of the values of the column but the absolute of the total of DIF_M1 L3.
My question is the following,
How can I get the sum of ABS_M1 L3 as total at the end of the column?
Hi @Anonymous
Try
ABS_M1 L3 = SUMX ( Table1, ABS ( [Sum MFR1 L3] - [Sum Actuals L3] ) )
You'd need to show the structure of your tables and the definitions of your measures to allow a more accurate solution
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
94 | |
86 | |
69 | |
65 |
User | Count |
---|---|
232 | |
128 | |
116 | |
82 | |
82 |