Forum Discussion
Solved
Distinct group sum
Hi Guys I just need the dax measure for the following i need to get the distinct productkey sum(productvalue) is this possible to do it in one measure? Much appreciated guys Year BoxKey Pro...
Kisame01 ,
Something like this?
Calculated column
Expected Result = DIVIDE(
CALCULATE(
SUM('Table'[ProductSubcategoryKey]);
FILTER('Table';
'Table'[ProductKey]=EARLIER('Table'[ProductKey])));
CALCULATE(
COUNT('Table'[ProductKey]);
FILTER('Table';
'Table'[ProductKey]=EARLIER('Table'[ProductKey]))))Greets,
Ronald
Hi Roland,
Not too sure what happens here. But I basically just need in this example Productkey 59's Product value will be 1.0773288/2 because there are 2 product keys of 59. The 1.0773288 is the full amount for the productkey 59, If that makes sense.
So this is what my epected result should be. If it makes sense
| Year | BoxKey | ProductKey | ProductSubcategoryKey | Product value | Expected Result | |
| 2016 | 1 | 59 | 3605489 | 1.0773288 | 0.5386644 | |
| 2016 | 1 | 59 | 332652 | 1.0773288 | 0.5386644 | 1.0773288 |
| 2016 | 1 | 60 | 1829472 | 6.42357297 | 1.070595495 | |
| 2016 | 1 | 60 | 2023932 | 6.42357297 | 1.070595495 | |
| 2016 | 1 | 60 | 386652 | 6.42357297 | 1.070595495 | |
| 2016 | 1 | 60 | 1928892 | 6.42357297 | 1.070595495 | 6.42357297 |
| 2016 | 1 | 60 | 1827084 | 6.42357297 | 1.070595495 | |
| 2016 | 1 | 60 | 1727724 | 6.42357297 | 1.070595495 | |
| 2016 | 1 | 61 | 1680492 | 45.57100824 | 9.114201648 | |
| 2016 | 1 | 61 | 1876760 | 45.57100824 | 9.114201648 | |
| 2016 | 1 | 61 | 1827408 | 45.57100824 | 9.114201648 | 45.57100824 |
| 2016 | 1 | 61 | 36732 | 45.57100824 | 9.114201648 | |
| 2016 | 1 | 61 | 1732332 | 45.57100824 | 9.114201648 | |
| Total | 51.99458121 |
Magic Roland. :smileyvery-happy: