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:

enter image description here

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:

enter image description here

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

0

There are 0 best solutions below