Forum Discussion
Switch returns wrong totals despite SUMX
Hi Community, I am new to Power BI. I am trying to build a Balance Sheet from an financial statement which has a few line items recalculated. I want the code to sum up the Balance sheet using f...
amitchandak
Super User
Super UserJewb16 , Try like , assumed you fact name is fact
SUMX(summarize(Fact, 'DIM_Structure'[Account],DIM_Date[Monatsname])),
switch(
TRUE(),
selectedlevel = "Ergebnis der Periode", PnL,
and (selectedlevel = "Gewinnrücklage", MAX(DIM_Date[Monatsname]) = "Dezember"), 10,
[TotalAmount]
)
)