Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
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
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))
It doesn't work, it's two text fields that are compared and
it doesn't do it neither with <> nor with -=
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