Pivottable Measurements Groups AND Condition

[joshuahirsch]

Hi there,

I'm having a question:

I want a pivot table where the user can see, if a salespartner added  data, it's getting a yes ("ja"), if not its a no.
I can group these salespartners to Regions, and ONLY if EVERY sp in a region added data, there shall be a "yes" in the pivottable. Instead, as soon as there is ONE "yes" the whole region is set to "yes".

How can i fix this?

[Clever_Anjos]

What is current measure expression?

[marcus_sommer]

You could try something like this:

if(count(Field) = count({< Field = {'no'}>} Field), 'Ja', 'Nein')

- Marcus

[joshuahirsch]

Hi, the current expression is depending on the date. Only if they added something, a date exists.

if(Count(distinct [Date])>0,'Yes','No')      translated

[marcus_sommer · Accepted solution]

Maybe something like this might work:

if(wildmatch(concat(aggr(if(Count(distinct [Date])>0,'Yes','No'), Vertriebspartner), ','), '*No*'), 'No', 'Yes')

- Marcus

[joshuahirsch]

Holy!
That feels like magic!

Thank you so much Marcus!