Count of a Dimension, with mutliple conditions

[wvanardoy]

I am trying to do a product efficiency analysis and trying to count the number of items being foretasted.

I need a count of all the unique Items at the color level, in the data source of Forecast, for the latest season (called MaxValue). The formula I am trying to use is not coming up with any results. I am not sure why, so any support would be greatly appreciated.

=Count({<[Data Source]={$(='Forecast')},MaxValue={$(=Max(MaxValue))}>}DISTINCT[Colorway Code])

[sunny_talwar]

Can you try this

=Count({<[Data Source] = {'Forecast'}, MaxValue ={"$(=Max(MaxValue))"}>} DISTINCT [Colorway Code])

[vishsaggi]

May be try this?

=Count({< [Data Source]={'Forecast'}, MaxValue={$(=Max(MaxValue))} >}DISTINCT[Colorway Code])

[wvanardoy]

Sadly this did not return any results either.

[wvanardoy]

Thank you, this got results, but they are not what I was anticipating.

[sunny_talwar]

When you say this, can you point out what worked in getting an output? Also, what are you getting and what do you expect to get? May be share a sample to show the issue