A measure to evaluate the outcome of other measures.

[Newrr]

As part of an audit process, a number of tables are received containing data relating to different incidents in different departments . For example, a table from Health& Safety department will list any safety incidents, a table from Security department will show suspected security breaches, another table from Staffing department provides information about staff absences. etc.etc.

Apart different measures in place to calculate different KPIs, I have one simple measure for each table to calculate the number of incidents in each department. Ideally all departments should have zero incidents but if atleast 8 out of 10 departments show no incident than the audit will be considered "Passed" otherwise it's a fail.

Now what I would like your help with is how to create a measure which will give the outcome of "Passed" or "Failed" on a card visual, based on the outcome of the incidents count measures.

I hope I have made myself understood but apologize in advance I am  unable to share any data.

Thanks 

[TomMartens · Accepted solution]

Hey @Newrr ,

create a new measure like so:

new measure:
var dep1 = if( [dep1measure] > something , 1 , 0 )
var dep2 = if( [dep2measure] > something , 1 , 0 )
...
var dep10 = if( [dep10measure] > something , 1 , 0 )
return
if( dep1 + dep2 + ... dep10 > somethingdifferent , "Fail" , "Pass" )

Hopefully, this provides what you are looking for.

Regards,

Tom

[Newrr]

Hi @TomMartens  Great, it works. Thank you so much for your help. Your solution perfectly meets my requirement however how would you amend it if alongaide "Fail" and "Pass", I also what to show how many departments had zero incidents and how many had one or more incidents?