Forum Discussion

JeffreyBl's avatar
JeffreyBl
New Member
4 years ago
Solved

Calculate new column with WHERE function

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...

Need Help
  • Thejeswar's avatar
    Thejeswar
    4 years ago

    Hi JeffreyBl ,

    You can use it like shown below

     

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

     

    Regards,

3 Replies

  • AntonioHR's avatar
    AntonioHR
    Icon for Helper I rankHelper I
    4 years ago

    Hello JeffreyBl 

     

    This should work _

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

  • Thejeswar's avatar
    Thejeswar
    Icon for Super User rankSuper User
    4 years ago

    Hi JeffreyBl ,

    You can use it like shown below

     

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

     

    Regards,

  • mh2587's avatar
    mh2587
    Icon for Super User rankSuper User
    4 years ago

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