Calculated field of two objects

Hi @Etai, please try something similar to this:

ifelse(
    {Report Type} = 'count' and {Site Name} = 'd', 3,
    {Report Type} = 'count' and {Site Name} in ['a', 'b', 'c'], 1,
    1
)

In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and post it on a new thread – since this post is already 7 days old. (Details on using Arena can be found here - QuickSight Arena