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
I am brand new to Power BI.
When calculating a new measure in an activity based costing model that I am building, it is returning a huge number. Can anyone help with this? The measures have worked well for all of the other totals that I am using in other sheets as below:
Can anyone help out here please?
Thanks!
I'm sure a book will help you.
In the meantime, is MM a calculated column or a measure?
@Triathlonboy , Multiplication need to be done either at row level or at some group by and rollup
example using common dimension
Sumx(Values(DIm[Dim ID]) , calculate( Sum(Table[V1]) *Sum(Table2[V2]) * SUm(Table3[V3]) ) )
Hi,
This response does not make any sense to me sadly, I think I need to buy a book!
Thanks
Ian
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 |
---|---|
99 | |
94 | |
85 | |
69 | |
65 |
User | Count |
---|---|
244 | |
127 | |
119 | |
81 | |
78 |