Dax to Filter duplicate

[Gaurav_84]

Hi Experts,

I am unable to filter duplcate value while performing calculate or sum. I want to show the correct budget amount against my project & GL. Below is an example of how my data look like.

Right now i am getting result as Project A00001 total Budget showing as $960 & Project B00001 is $2,200. which is incorrect.

Correct budget figures should be Project A00001 is $480 & Project B00001 is $1100.

Regards

Gaurav

[amitchandak · Accepted solution]

@Gaurav_84 , Try a measure like

measure =

Sumx(summarize(Table,Table[Project], Table[Budget]), [Budget])

or

measure =

Sumx(values(Table[Project]),calculate(Max( Table[Budget])))