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

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 IV
Super User IV

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!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

View solution in original post

3 REPLIES 3
Highlighted
Super User IV
Super User IV

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. 


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

Putting square pegs in round holes since 1972.

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 IV
Super User IV

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!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Super User IV
Super User IV

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!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

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

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors