Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
which syntax must i use, if i want to use a dimension and want to ignore the selection in field country?
Like that, but this syntax is not correct:
({<country= >} products)
regards,
Fritz
How do you define varName? Can you share the expression that drives varName?
Hi Walter,
Use somehting like this:
sum({< country = >}Sales)
Thanks,
Sangram.
May be give this a shot:
Aggr(Only({<country = >} $(=Pick(Match($(varName),1,2),'products','categories'))), $(=Pick(Match($(varName),1,2),'products','categories')))
Can you explain which part of your chart is influenced by selection in country?
As far as I see, the dimension
$(=Pick(Match($(varName),1,2),'products','categories'))
is a synthetic Dimension not linked to your data model at all.
What are your expressions? You said, you are not using sum(), count() or anything like this, but you should:
I assume you are just using a FieldName as expression, which is equivalent to
=Only(FieldName)
If so, add the set analysis to the Only() function, or any other appropriate Aggregation
=Only({<Country= >} FieldName)
edit: Ah, Should have read the complete thread
products and countries are field names, right?