Count years if there is a invoice in each year

[stiani]

I have a table with Invoices

Invoice table:

• ID-nr 
• Projectnr  [text]
• Invoice text [text]
• Year [number]
• Month
• Amount  [number]

  Im visualising this in a table with:

  Projectnr - amount 2015 - amount 2016 - amont 2017 ... and so on to 2021.

  And now i need a measure as a column in this tablevisualisation that count if the invoice amount is bigger then 0 for each year pr projectnr, like this:  

  For example "project 1"  has invoices in every year since 2015. Project 1 counts to 6. 

  For example "project 2" has invocied only since 2020. Project 2 counts to 2.

  Im stuck at: 

  Measure count = count(if...  

[stiani]

Just what i needed. Thanks!

[Greg_Deckler · Accepted solution]

@stiani Perhaps:

Measure = COUNTROWS(FILTER(SUMMARIZE('Table',[Year],"__Amount",SUM('Table'[Amount])),[__Amount]>0))