Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
28 | |
21 | |
12 | |
8 |
User | Count |
---|---|
74 | |
51 | |
45 | |
16 | |
12 |