Customized flags and expression

[ilanbaruch]

hi all,

in my model i have a pivot table with Product_id and month as a dimension,

sum(flag) - as an expression

result is as below :

id	month	Jan-18	Feb-18	Mar-18	Apr-18	May-18
123		1	0	0	1	0
124		1	1	1	0	0
125		0	0	1	1	0
126		1	1	1	1	1
127		0	1	0	1	0
128		0	1	0	1	0
129		1	1	1	1	1
130		0	0	0	0	1
131		0	0	0	1	1
132		0	1	1	1	1

i want to create a flag  - for filtering or to use within an expression or or a calculated dimension

and the result will show only the id's with 1 value in the pivot table - 

sum(flag)=1 in all months selected.

id's -126, 129 in the above table

any ideas?

advanced thanks

[marcus_sommer · Accepted solution]

Maybe as a calculated dimension within a listbox:

if(aggr(count(distinct month) = sum(flag), id), 'all flags are 1', 'flags are missing')

- Marcus

[ilanbaruch]

Thank You Marcus. it works!
my final
=if(aggr(count(distinct month) = sum(ShowFlag), id), id)