How can I count value of a measure & how can I select values ​​of a measure?

[hvantoni]

I want to compare two fields. If they match correct value ok and if not value does not match. 
later I want to be able to select the ones that do not match and be able to count them



verifica_router is a measure
if([ÚltimaEthenet]=[Ethernet_Declarada] , 'OK ', 'nocoincide')



 

[ckarras22]

verifica_router can be a dimension as well (selectable). 

to count them, you can have a simple KPI like sum(if([ÚltimaEthenet]<>[Ethernet_Declarada] , 1))

[hvantoni]

It doesn't work, it's two text fields that are compared and 
it doesn't do it neither with <> nor with -=

[oskartoivonen · Accepted solution]

You can try feeding the fields into the Match-function if you want to compare them 1:1. Wildmatch-function allows for wildcards as well.

if(Match([ÚltimaEthenet], [Ethernet_Declarada]), 
    'OK ', 
    'nocoincide'
) as CompareField