Count Match

[Anonymous]

Hi,

I am having an issue with my count for matches values. As you can see below the count seems to be including an additional column (highlighted in yellow):

The expression I am using is for this pivot table is:

Row: =IF(OrderPODDateYear>2017,PODDATEMONTH)

Column: =If(Match([PriorityLevel],'AOG','Routine'), PriorityLevel)

Measure: =count(DISTINCT OrderID)

Is there something I can do so it only returns Routine and AOG figures?

Thanks

[YoussefBelloum · Accepted solution]

Hi,

Try just filtering on the expression, like this:

=count(DISTINCT {<PriorityLevel={"=Match([PriorityLevel],'AOG','Routine')"}>} OrderID)

[Anonymous]

THANKS!

it worked

[YoussefBelloum]

You're welcome!

to simplify, this will also work:

=count(DISTINCT {<PriorityLevel={'AOG','Routine'}>} OrderID)

[Anonymous]

Thanks again!