Question measure

[rodybrinkhuis]

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. 

Periode	Volledige naam	Total
1-1-2020	Brad Pitts	2
2-1-2020	Angelina Jolia	1
3-1-2020	George Cloonei	1
4-1-2020	Adelee	2

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]

Hello,

Try using IF.

If(

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

>1,

Periode

)

Thanls,

Ashutosh

[rodybrinkhuis]

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

[AshutoshBhumkar]

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

[rodybrinkhuis]

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)