Forum Discussion

Murali777's avatar
Murali777
Helper III
4 years ago
Solved

Monthwise total using DAX

Hi,   Below is my request to figure out the MonthwiseTotal column using DAX measure. I have tried using TotalMTD function but it is working. Can any one pls help on this.    
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    The table

    the measure ==>

     

  • Anonymous's avatar
    Anonymous
    4 years ago

    hi Murali777 

     

    You can use this measure

    MonthwiseTotal = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[End Of Month]))
     

    If this post helps, accept it as a solution.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

hi Murali777 

 

You can use this measure

MonthwiseTotal = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[End Of Month]))
 

If this post helps, accept it as a solution.

Murali777's avatar
Murali777
Helper III
4 years ago

Hi Esha,

Please see this example below, i have removed the user C an D from the second table but still it is summing all the users value. I need to sum only the selected user values. Please help me with this example.