Forum Discussion
Solved
Issue with calculated column - sum in unique
Hi I have raw data as below. Trying hard to get pivot as shown in second image. Product column has a slicer.
Hi Greatbi1 ,
You can create a measure to get total volume affected--base on unique product volume just like below:
Total volume effect = VAR _tab = SUMMARIZE ( 'Products', 'Products'[part group], 'Products'[Product], "price", MAX ( 'Products'[volume of product] ) ) RETURN SUMX ( _tab, [price] )Best Regards
Rena
3 Replies
Hi Greatbi1 ,
You can create a measure to get total volume affected--base on unique product volume just like below:
Total volume effect = VAR _tab = SUMMARIZE ( 'Products', 'Products'[part group], 'Products'[Product], "price", MAX ( 'Products'[volume of product] ) ) RETURN SUMX ( _tab, [price] )Best Regards
Rena
- amitchandak
Super User
Greatbi1 , You can use distinctcount , count and sum as per need to get these
- parry2k
Greatbi1 Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
