topic Re: How can I count value of a measure & how can I select values of a measure? in App Development

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

hvantoni — Sun, 23 Oct 2022 17:27:33 GMT

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')

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

ckarras22 — Sun, 23 Oct 2022 18:09:32 GMT

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))

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

hvantoni — Sun, 23 Oct 2022 18:25:34 GMT

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

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

oskartoivonen — Sun, 23 Oct 2022 20:44:10 GMT

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

topic Re: How can I count value of a measure & how can I select values ​​of a measure? in App Development

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

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

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

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

topic Re: How can I count value of a measure & how can I select values of a measure? in App Development

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

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

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

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