Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,766 questions
How to fix summarize formula in Power Pivot
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 9%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Juan David Martinez Lizarazo
0
Reputation points
I am trying to write a summarize formula in power pivot DAX, but despite the syntax of it being correct and the columns I'm trying to add up being set as values, I'm still getting an error. Can somebody please help?
thanks!
Office
{count} votes
-
Juan David Martinez Lizarazo 0 Reputation points
2023-11-17T11:12:29.0366667+00:00 here is the Dax Formula I'm writing:
Measure 1:=SUMMARIZE(Table2,Table2[User],"invest",sum(Table2[Inv])).
despite column "Inv" type being set up as whole number, I'm still getting an error. Also, column "User"'s type is set as text, so I have no clue why is this not working.
Sign in to comment
Sign in to answer