Forum Discussion

rtreble's avatar
rtreble
Frequent Visitor
8 years ago

Counting measures

Hi   We are looking at flagging whether the average time taken for a machine to do it's thing on a particular day is either above or below control limits (which are mean +/- 3 standard deviations f...
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

HI rtreble

 

Something along these lines should work

 

Measure = COUNTROWS( FILTER  ( <yourtable> , [Flag_Binary] = 1 ) )
rtreble's avatar
rtreble
Frequent Visitor
8 years ago

Hi Phil

 

Thanks for your post ... having trouble getting it to work though ... does your solution apply to counting rows in a table - what I'm after is counting results of a measure.

 

R.

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    What I suggested was a measure that counts rows in a table.  

     

    Do you have a screenshot of your table?  Or can you post a sample version of your data