Good morning Charles
There are several ways to do this
this (without LOD)
If Min([Indicator 1],[Indicator 2]) >0 the countd(ID) End
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Please use this calculation:
COUNTD( if Min([Indicator 1],[Indicator 2]) >0 then (ID) END)
Thanks and please find attached workbook.
countof id_v10.2.twbx 48.7 KB
Thanks for the reply! I'm assuming I am supposed to create a calculated field with this formula and drag it on to my ID measure? However when I create this calculated field , it gives the error "Expected 'THEN' to match 'if' at character 0" at the expression 'the.' If I change it 'the' to 'then,' it red underlines the whole expression with the error "cannot mix aggregate and non-aggregate comparisons or results in "if" expression."
Thanks very much.