While Creating a Balance Sheet in Power BI im using a Switch in a Measure to load the corresponding Numbers to the position in the Report. At the moment it shows an empty value see 1. I try to get it to look like see 2:
The Switch:
Actual PY = SWITCH(
SELECTEDVALUE(financialStatementStructure[accountId]),
100, FORMAT([100], "#,##0"),
1, FORMAT([currentAssetsInPercent], "0.0%"),
200, FORMAT([200], "#,##0"),
300, FORMAT([300], "#,##0"),
400, FORMAT([400], "#,##0"),
500, FORMAT([500], "#,##0"),
600, FORMAT([600], "#,##0"),
700, FORMAT([700], "#,##0"),
800, FORMAT([800], "#,##0"),
900, FORMAT([900], "#,##0")
)
Measure [currentAssetsInPercent]:
currentAssetsInPercent = DIVIDE([100], [400], 0)
Connection between the tables:
Slicers for the Table:
unitNumber
year
quarter
Measure [100]:
100 =
CALCULATE(
SUM('combinedAccountValue'[value]),
FILTER(
ALL('date'),
'date'[yearQuarter] = (SELECTEDVALUE('date'[yearQuarter]) -10)
),
'combinedAccountValue'[accountId] = 100,
'combinedAccountValue'[reportTypeId] = 1
)
Measure [400] looks similar to this. Those measures involve the Filter for reportTypeId. This should give a uniq row to lookup in the accountValue table.
This works fine for the Card Visual but not for the Table. What do i miss out here? :S
This is just an example as i cannot show the actual balance sheet. Therefore i can also not upload the PBI-File

