Hi All,
Hope all is well.
I'm new to DAX, and I'm trying to write a DAX formula that would sum the "Element Quantity" field, but only for each unique "Element Data" value. Example file is attached.
Input
Input.JPG
Expected Output
Output.JPG
Thank You.
Andrew
Mcode in Power Query
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Great. Thanks Alan!
Please try Measure
=SUMX(SUMMARIZE(QueryTable,[SKU],[Element Data],"EQ",AVERAGE([Element Quantity])),[EQ])
or
=SUMX(GROUPBY(QueryTable,[SKU],[Element Data],"EQ",AVERAGEX(CURRENTGROUP(),[Element Quantity])),[EQ])
Last edited by Bo_Ry; 01-18-2022 at 12:54 PM.
Brilliant. Thank you for this! I'm still learning the iterator functions but that's definitely going to help a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks