Forum Discussion

Gaurav_84's avatar
Gaurav_84
Icon for Helper I rankHelper I
5 years ago
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.

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

Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    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])))

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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])))