Add rows together depending on another row/column value

[Bagpuss]

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 measure I have created?

Thanks

[Anonymous]

@Bagpuss 
I think I can get a bit of your requirement but not very clear. You could take get the sum with:

Measure = SUM([actuals to period]) 

Then use slicer to select the value. See example:

 

If not clear, you might want to look at this post see how to post quesiton with sample. 

Read this post to describe your sample:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 

Basically, provide an expect output and clearly describe the logic of the calculation. So we can give a exact dax formula.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Bagpuss]

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]

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" }

)

[camargos88]

@Bagpuss ,

Can you provide data as example ? Also the input and desired output.

[Bagpuss]

Hi Camargo

Thanks for you're help. I will try my best.

Below is a snippet from the  table (excel) I am working from. This table contains a lot of ledger codes with various numbers but I need to get the total sum from adding together the 'actuals from period' column but from a selection defined by specific Ledger codes within the table and then take that as a percentage from another figure. The other figure I have calculated in a measure so I guess I can just add that to some Dax code but where I am struggling is to get the total from a selection from the 'actuals to period' column defined by/filtered by specific ledger codes.

I could do this in Excel and maybe I need to do this and then import it into PBI but it would be great to not have to.

I have tried creating various measures but I'm getting nowhere and part of me thinks I need to go about it another way but I'm not sure how. Any help would be greatly appreciated.

[Bagpuss]