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 👍🫡
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!
sorry , didnt get a notification that you replied. i think it is because of the many spam questions which are slowing the system
that being said, im glad it worked out for you
always happy to help. appreciate the kudos 🤠
