Forum Discussion
Sums in Matrix
let me know if this works for you .
measure :
switch (
true() ,
isinscope( tablename[user] ) || isinscope( tablename[account] ) ,
max(bookedtime (hours) ,
sumx(
summarize(
tablename,
table_name[account],
table_name[account],
table_name[bookedtime (hours)]
),
table_name[bookedtime (hours)]
)
let me know if this works for you !If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos 👍🫡
Daniel29195
hi! thank you! yes, the formula works in the example I provided, but when I applied it in my data model I received an error. A single value for the similar bookedtime (hours) column cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
Daniel29195 it seems i made a syntax mistake 🙂 it works now,. thanks!