Forum Discussion

hansaraneda's avatar
hansaraneda
Icon for Helper I rankHelper I
5 years ago
Solved

help with measure

I need to take a measure and place it in all the rows. to later perform a subtraction between two variables, I can calculate the measure but I cannot replicate it in all the rows or perform the calcu...
Need Help
Tips and Tricks
Tutorial Requests
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    @hansaraneda You can add ALL() if you want it to be calculated on all data/rows.

    previous balance amount 2 - DIVIDE(CALCULATE(SUM(Query1[saldo_anterior])),(CALCULATE(SUM(Query1[saldo_anterior]),Consultation1[Label]-"Entry of Ordinary Activities", ALL())),0)

hansaraneda's avatar
hansaraneda
Icon for Helper I rankHelper I
5 years ago

Hello alisson, I found the problem, what happens is that in that report I have a data segmenter of the years, but that calculation is calculating all the years for "income from ordinary activities", how can I do so that it only considers the selected year? . thanks