Forum Discussion
Anonymous
7 years agoNot applicable
Sum based on unique ID
Hi Guys, I have a problem which shouldnt be that difficult to solve, but I'm new to DAX and can't handle it. What I am searching for is the Sum of values based on a ID. Example: ID | V...
richardverburg
7 years agoHelper I
Can you try the following code:
SUMMARIZECOLUMNS(Tags[value], "ID", COUNT(Tags[value]))
https://msdn.microsoft.com/en-us/query-bi/dax/summarizecolumns-function-dax
Anonymous
7 years agoNot applicable
Thanks for your answer. Im getting the following Error:
"The expression refers to multiple columns. Multiple Columns cannot be converted to a scalar value"