Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Why need to add INVC before sum up Qty on hand and unit cost ?

‎12-04-2020 09:19 PM

Hi All

Paulyeo11_0-1607145474675.png

 

Labels:
Message 1 of 3
410 Views
0
1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

‎12-04-2020 10:59 PM

Hi @Anonymous 

The first paramater for SUMX is the table containing the rows that will be evaluated in the expression. INVC is the name of your table.

https://docs.microsoft.com/en-us/dax/sumx-function-dax

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

Message 2 of 3
367 Views
0
2 REPLIES 2
PhilipTreacy
Super User
Super User

‎12-04-2020 10:59 PM

Hi @Anonymous 

The first paramater for SUMX is the table containing the rows that will be evaluated in the expression. INVC is the name of your table.

https://docs.microsoft.com/en-us/dax/sumx-function-dax

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Message 2 of 3
368 Views
0
Anonymous
Not applicable
In response to PhilipTreacy

‎12-05-2020 02:32 AM

Hi Phil

thank you for sharing 

so that it will be able compute in aggregate 

Message 3 of 3
346 Views
0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

View All