Power Bi Running total ; put in blank rather than repeat final figure.

[dicken]

Hi,
I have a running total in power bi, one using the date column of 'sales' and the other using the Calendar table, I'd like to use the calendar table
but because it has every date I get date repeated where there is no current data, I'd like the matrix on the right to filter down to just relevant 'rows;' or have a blank or 'no data' or something rather than repeating the figure for march all the way down .
Any suggestions,

Richard

 

[Matt Allington]

=if([tsales]<>0, [your running total measure])

 

[dicken]

=if([tsales]<>0, [your running total measure])

Thanks,

RD

 

[dicken]

=if([tsales]<>0, [your running total measure])

Hello Matt,
Just watch Chandeep on Goodly, and saw this; just use the IF, so;

Using calendar = measure ,

   =  IF([tSales] , [Using Calendar] )

and thel empty 'rows' disappear ' as they do in power pivot.

RD