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

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