How to count values for filled columns

[Anonymous]

Hello, 

I would like count KPI compliancy by settings. I need 3 measures:

• COMPLIANT: Sum of column compliant
• NON - COMPLIANT: Sum of column non - compliant
• Error: Sum of column error

and this is not hard, but I need to take into account too following stuffs: 

Each row has to filled 3 columns: 

• asset name 
• asset status 
• asset class (yellow columns)

or this 3 columns: 

• name 
• fqdn 
• IP (green columns)

I can only count values if I have complete values at first in columns: asset name, asset status, asset class and if I don't have values in this 3 columns I take into account this 3 columns: name, fqdn, IP. 

For example: If I have blank value for yellow and green columns I shoudn't count values for row 21: 

Could you help me? I have no idea how to do this. 

[Anonymous]

Hi @Anonymous ,

How to get the value [COMPLIANT] ? Now the value of the 21 row is 315.  How much it was supposed to be? Could you provide a sample file without privacy information and desired output ?

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.