Forum Discussion
Accounting balance remove zero rows
I have created this accounting Balance: Each year is calculated as all transactions for a given account-number since beginning of time 🙂 To do that I use this measure: [Bogført bel...
Hi Bokazoit
Depending on the timeframe you have chosen, there could be entries in prevous years that are in your slicers timeframe. Leave the original measure in the visual, highlight the visual and in the filter pane on the left, go to the measure and choose "Is not 0".
If that doesn't work adapt your measure
[Bogført beløb (Balancen)] =
VAR LastYear = MAX( DimDato[Dato] )
IF (
CALCULATE (
SUM ( FactFinans[#Bogførtbeløb] ),
FILTER ( ALL ( Dimdato ), DimDato[Dato] <= LastYear ) ,
DimKonto[Kontonummer] >= 6000
) = 0, BLANK(),
CALCULATE (
SUM ( FactFinans[#Bogførtbeløb] ),
FILTER ( ALL ( Dimdato ), DimDato[Dato] <= LastYear ) ,
DimKonto[Kontonummer] >= 6000
)
Joe
It changes nothing