The largest independent gathering in the world for the Microsoft Business Applications ecosystem is a 'For User, B y User' event. It brings immense value to the User Community when insights are shared from those that are on the same journey, ...
James, Thanks for your reply! I got the script fixed. I was close, but not quite right. The correct script is: = sum('AWD-RbA Append'[Occurrences Total]) * sum('AWD-RbA Append'[Adjusted Cost]) Thanks! Bob McMullen.
Is the number you [sum of cost] * [sum of occurrences] ? What you have been calculating is the sum of [cost] * [occurrences].
If you a product with two rows in the database:
Occurrences Cost Occur * Cost 1 ...
See if switching from calculated column to measure helps
HASONEVALUE ( Tabela[Name] ),
SELECTEDVALUE ( Tabela[Calendar Type] ) = "Booked To A Project" && [Allocat] < 1, "Partially Available", ...
You could give them an alternate source location for the list. If they can access a SharePoint list, or an excel spreadsheet stored online in SharePoint or OneDrive or another available source you could set up the report to iterate through that stored ...