Calculate new column with WHERE function

[JeffreyBl]

Hi,

I'm trying to create a new field via a new formula in which I use the WHERE function.

Billable uren = 'DEA-Amsterdam'[Totale uren] WHERE 'DEA-Amsterdam'[Omzetwaarde] > 0'

I want to calculate the number of hours WHERE value is higher then zero (o)

Unfortunately an error shows...

[mh2587]

Column = Calculate(sum([Totale uren] ),'DEA-Amsterdam'[Omzetwaarde] > 0)

[Thejeswar · Accepted solution]

Hi @JeffreyBl ,

You can use it like shown below

Billable uren = CALCULATE(SUM('DEA-Amsterdam'[Totale uren] ),  'DEA-Amsterdam'[Omzetwaarde] > 0)

Regards,

[AntonioHR]

Hello @JeffreyBl 

This should work _

Billable uren = CALCULATE('DEA-Amsterdam'[Totale uren],'DEA-Amsterdam'[Omzetwaarde] > 0')