Forum Discussion

prashantPBI's avatar
prashantPBI
Regular Visitor
9 years ago
Solved

Summing values in a field

Hi Everybody,   I am working on some Health and Safety Data - could you please help with my problem.   I have a cloumn for Safety Classifications, within the coulmn I have Safety Interactions, Go...
  • Anonymous's avatar
    Anonymous
    9 years ago

     If I understood...

     

     

    Proactives = CALCULATE(COUNT('Data Tracker'[Safety Classification]), 'Data Tracker'[Safety Classification] = "Safety Interactions" ) + 
CALCULATE(COUNT('Data Tracker'[Safety Classification]), 'Data Tracker'[Safety Classification] = "Good Catch" )

     

    If I not understood, can you show your data?

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

prashantPBI,

 

Create a new measure with the follwing code:

 

Proactives = COUNT(YOUR_TABLE[Safety Interactions]) + COUNT(YOUR_TABLE[Good Catch])

 

Hope it helps!

prashantPBI's avatar
prashantPBI
Regular Visitor
9 years ago

Hi Anonymous

 

Thanks. But I should have been clearer. Both Safety Interactions and the Good Catch are within the same column in the table 

 

So my table name is Data Tracker - 

Column name is Safety Classification

The Safety Classification column has all the designations like Safety Interactions and Good Catch and I am having trouble summing that up. 

 

Hope that makes sense.