Forum Discussion
MasterSonic
Helper IV
Helper IVcumulative sum or count
Hi guys, I have 2 tables - first with uniqe codes second with dates and category (A,B,C) I have created this : Count of dates = CALCULATE( sum('Col1'[code]), FILTER( A...
MasterSonicHelper IV
Helper IVI got this one so it works per category.ðŸ¤
I think I cannot use filter on visual level, so needed to do this.
Also I referred to dates within my table not to Date table I created previously.
Column = CALCULATE(DISTINCTCOUNT(‘Col1'[code]))
/
10 = CALCULATE(SUM('Col1'[Column]),'Col1'[Category]="C")
/
cumulative =
var AB = SUM(‘Col1’ [Column])
return
CALCULATE(
'Col1'[10],
FILTER(
ALLSELECTED('Col2'[Date]),
'Col2'[Date]<= MAX('Col2'[Date]]
))
)
/
Could you just tell me how to do not count blanks from Col2[Date] please?
