cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Dax

I need help building a DAX in a way that calculates the sum of the 2 given rows of FY16-17 and outputs in a single row and also to remove the [1L] and [100 ML] from the row.

 

ignore the Total

 

Current-

Capture.PNG

 

Desired -

Capture1.PNG

 

@amitchandak 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IX
Super User IX

Re: Dax

@Nimai123 , Try sumx

Measure 2 = SUMX(SUMMARIZE('Product Sales Report','Product Sales Report'[All Segment.All Segment Level 01],'Product Sales Report'[Material.Material Level 01],"_1",[Total Qty Inc Foc FY16-17]),[_1])

 

Add all the group column of table

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

3 REPLIES 3
Highlighted
Super User IX
Super User IX

Re: Dax

Is that all of your data? You could create a new column like:

 

Material = LEFT([Materials,FIND([Materials],"[") - 1)

 

Then just put that in your visual and you should get a single row and the sum you want. 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Super User IX
Super User IX

Re: Dax

Try like

averagex(summarize(table,Table[product category],Table[material],"_1",[<Your measure>]),[_1])



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Super User IX
Super User IX

Re: Dax

@Nimai123 , Try sumx

Measure 2 = SUMX(SUMMARIZE('Product Sales Report','Product Sales Report'[All Segment.All Segment Level 01],'Product Sales Report'[Material.Material Level 01],"_1",[Total Qty Inc Foc FY16-17]),[_1])

 

Add all the group column of table

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors