Forum Discussion

Kisame01's avatar
Kisame01
Frequent Visitor
7 years ago
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's avatar
Kisame01
Frequent Visitor
7 years ago

Hi Nick_M, thanks for the response

 

Maybe my question wasn't to clear if you look at the product key and the product value for those product keys are exactly the same. 

 

So i want to be able to actually group all of the productkeys together and devide the product value by the number of ProductSubCategoryKeys because. Looking at Productkey 59 both subcatecorykeys '3605489' and '332652' make up the productvalue of '1.0773288' so i need a new column with new values so I can get the true sum of the value.

 

Nick_M I hope I am making sense, or I am not even sure if I am over complicating things.

 

Thanks again :smileyhappy:

 

Ronald123's avatar
Ronald123
Icon for Resolver III rankResolver III
7 years ago

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