topic Re: Question measure in Search the Community

Question measure

rodybrinkhuis — Thu, 28 Oct 2021 06:23:35 GMT

Hello,

I have a question.

I have a measure called total:

Count(DISTINCT{<Soort={'OMD','Leerlingenvervoer'}, AantalRitten={'1','2'}>}Client)

I have the following result in a table.

Now i want only the result of total>1. I just want to see the result of 1-1-2020 Brad Pitts and 4-1-2020 Adelee. How can i do this?

Greetings,

Rody

AshutoshBhumkar — Thu, 28 Oct 2021 06:38:42 GMT

Hello,

Try using IF.

If(

Count(DISTINCT{<Soort={'OMD','Leerlingenvervoer'}, AantalRitten={'1','2'}>}Client)

>1,

Periode

)

Thanls,

Ashutosh

rodybrinkhuis — Thu, 28 Oct 2021 07:26:52 GMT

Thanks for the answer. But i see in my table when i am looking at: total still the number 1.

AshutoshBhumkar — Thu, 28 Oct 2021 08:13:21 GMT

Could you provide any screenshot and an expression you have used.

rodybrinkhuis — Thu, 28 Oct 2021 08:34:23 GMT

Hello,

This is the table i have. In Totaal klanten LLV en OMD i am seeing 1 and 2. I just want to see 2.

You can see the measure Totaal aantal klanten LLV en OMD. The expression i am using was:

If(Count(DISTINCT{<Soort={'OMD','Leerlingenvervoer'}, AantalRitten={'1','2'}>}Volledige_naam)>1,Periode)