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'd like to calculate totals within L1 in the table where only L2 is available (2nd table to present 8 and 15 for a1,a2,a3 and b1,b2,b3 respectively instead of total of 23). Thus the calculation must know the context, that for eg. 'a1' 'a' is the base.
I currently use:
Any help appreciated.
Thank you.
Solved! Go to Solution.
Hi @raionpbi
You may refer to below measure:
Total L1 = CALCULATE ( SUM ( Tab1[value] ), ALL ( Tab1 ), VALUES ( Tab1[L1] ) )
Regards,
Cherie
Hi @raionpbi
You may refer to below measure:
Total L1 = CALCULATE ( SUM ( Tab1[value] ), ALL ( Tab1 ), VALUES ( Tab1[L1] ) )
Regards,
Cherie
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 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |