Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Table Total Sum with Filters

Hello Everyone.    I got stuck in a Table Total wich is not summarizing my rows.   I want to sum total sales by each invoice number filtering the last negotiation number. I have to consider only ...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Try a measure like

     

    sumx(values(Table[Invoice]), calculate(lastnonbalnkvalue(Table[negotiation number], sum(Table[Sales]))))

     

    or

    calculate(sumx(values(Table[Invoice]), calculate(lastnonbalnkvalue(Table[negotiation number], sum(Table[Sales])))) ,

    filter(allselected(Table), Table[Invoice] = max(Table[Invoice]) ) )

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Try a measure like

 

sumx(values(Table[Invoice]), calculate(lastnonbalnkvalue(Table[negotiation number], sum(Table[Sales]))))

 

or

calculate(sumx(values(Table[Invoice]), calculate(lastnonbalnkvalue(Table[negotiation number], sum(Table[Sales])))) ,

filter(allselected(Table), Table[Invoice] = max(Table[Invoice]) ) )

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak thank you very much! It worked pretty well here and solved my problem. 

    Really appreciate the fast reply and with a very good solution for this. Thank you!

     

    Just by the way, for any case, is it possible to aggregate also the blank values in last negotiation? 

    Like a condition. Sum sales with all blank values in last negotiation and, if there is a number, consider only the hightest in negotiation number. 

    This is just an extra thought and I will be working on that also. 

     

    One more time, thanks for the help. It really helped to solve this problem.