Forum Discussion

Bagpuss's avatar
Bagpuss
Regular Visitor
5 years ago

Add rows together depending on another row/column value

Hi Apololgies if this straight forward but I am new to Power Bi.    I have a table where I need to add together multiple rows of data that equal several different values and then divide that by a ...
Need Help
Bagpuss's avatar
Bagpuss
Regular Visitor
5 years ago

Thanks Paul for your reply and sorry for the delay, currently juggling projects. That would do it but I don't want the end user to have to use a Slicer, I want to filter the ledger codes where they equal a certain code and then take the Actuals to period where they are filtered by Ledger Codes and add them together. The end result being all the Actuals to Period added together where a ledger codes all start with 2 for example? I then need to take this figure and use it in another measure.

Bagpuss's avatar
Bagpuss
Regular Visitor
5 years ago

Think I figured it out by adapting a quick measure, used the below code and it appears to be adding all my actual to period values where ledger codes equal the list I have at the end of the measure DAX code 🙂

Now what would be really cool if it could add all codes up together starting with 2 as I have a lot but am I asking too much?

 

Total Salary =
CALCULATE(
    SUM('Ledgers'[Actuals to Period]),
    'Ledgers'[Ledger Code] IN {"2000-01","2001-01","2002-01" }
)