Filter is not working

[kfahri342]

Hi,

Unfortunately, the document I am working on is strictly private so I will be using a generic/made-up example to demonstrate my issue. I have two tables (1 x Pivot and 1 x Straight Table)

The pivot tables shows a summary table of how many purchases a consumer has made on a specific type of product. The expression is

Count({<[Type of Product]={ "Clothes", "Food*", "DIY"},
[Type of Consumer] ={"1"},
[Gender]={"*1"}>} Productid),

The Straight table uses the exact same expression but provides a breakdown of the types of Products the consumer has bought (e.g. Apples, Flowers etc.)

My issue is when I select Product Type = Food as a filter. Neither table seems to filter to this result only. The order of the columns and rows seem change, but the data doesn'tfilter.

Any ideas why?

Many Thanks

[sunny_talwar · Accepted solution]

Try this

Count({<[Type of Product] *= { "Clothes", "Food*", "DIY"},
[Type of Consumer] = {"1"},
[Gender] = {"*1"}>} Productid),

[kfahri342]

It worked. Thank you. Can you explain what the * does in this case?

[sunny_talwar]

Check here

Implicit Set Operators