Forum Discussion

MahiK's avatar
MahiK
Regular Visitor
3 years ago

Unique sum using DAX

PCode PNAME VALUE VC CE ABC 100 XX CE ABC 100 XY MNO 200 YY XM PQR 100 ZZ I want total sum for VALUE column it should only sum values for unique PCode,PName and Value combination like it should ...
Need Help
BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi MahiK ,

 

You could use a measure something like this:

_sum_PCode_PName_Value =
SUMX(
    yourTable,
    MAX(yourTable[Value])
)

 

You'd need to make sure you use it with the correct dimensions in a visual, otherwise it may give unexpected results.

 

Pete