Filter row with two different columns as a prerequisite to calculate a different row in one table

[Anonymous]

Hello dear Power BI community, I have the following problem, which I haven't been able to solve so far. My data table looks like this:

It's about rental income and operating costs for apartments, which are always in one line per month and are assigned to the respective apartment via the Identifier (last  Column in the right). There are other data records in the table that are not rent or operating costs, but they are hidden The aim should be to filter the Konto (H) column with the specification "60000 Miete" and if the Betrag (S) column = 0 (both marked yellow), the row underneath with the column Konto (H) should be filtered with the "60020 Betriebskosten" an column Betrag (S) can be mapped as a result in a measure (green marking). If the prerequisite is to meet several data sets in the same month, they should be summed up. The result from the mapped data for the measure should be

June = 120

July = 270

[Anonymous · Accepted solution]

Hi @Anonymous,

I check the snapshot that you provided but I can't find the corresponding record groups that can be aggregated.
Is there any field that can be used to remark these record groups? If that is the case, you can use the date field and that category field as conditions of summary records.

formula =
CALCULATE (
    SUM ( Table[Betrag] ),
    ALLSELECTED ( Table ),
    VALUES ( Table[Datum] ),
    VALUES ( Table[Category] )
)

Regards,

Xiaxoin Sheng