Forum Discussion
Solved
Dax to Filter duplicate
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....
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])))
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])))