Various filters in an expression

[RubenMoreno]

Hello, 

I am trying to create a measure including several filters/conditions. I have a table with several columns (Columns A, B and C) and I want to use "Count" expression but only when Column A and B have specific values.

I managed to do it for one column but I miss how to add the second condition.

Count({<[ColumnA]={'A'}>} ColumnC )

Could you please help?

Thank you.

Best regards,
Rubén

[Kashyap_R · Accepted solution]

hi

if you want to apply both conditions

Count({<[ColumnA]={'A'},[ColumnB]={'B'}>} ColumnC )

if you want either of the conditions 

Count({<[ColumnA]={'A'}>+<[ColumnB]={'B'}>} ColumnC )

Hope this helps

Thanks

[RubenMoreno]

Thank you, it helps!