Set Analysis (always include all except certain records)

[Anonymous]

Hi,

I am trying to calculate a value which I do not want to be affected by any selections made by the user. I always want it to calculate based on all the records.

This one below works fine and whatever selection the user makes, the calculated number stays the same:

sum({1}[Amount])/sum({1}[Quantity])

I then inserted a parameter like this:

sum({1}{<[Quantity]={">0"}>}[Amount])/sum({1}[Quantity])

The expression above calculates correctly the way I want it to. However if a user makes a selection, the value changes, which I do not want. I want it to stay fixed.

Any help? Thanks!

Attached file for reference.

[tresesco · Accepted solution]

You are almost there. Just need to correct brackets. Try:

=sum({1<[Quantity]={">0"}>}[Amount])/sum({1}[Quantity])

[kaushiknsolanki]

Try this,

=sum({1<[Quantity]={">0"}>}[Amount])/sum({1}[Quantity])

Remove the Extra {} from expression.

Regards,

Kaushik Solanki