Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You are almost there. Just need to correct brackets. Try:
=sum({1<[Quantity]={">0"}>}[Amount])/sum({1}[Quantity])
You are almost there. Just need to correct brackets. Try:
=sum({1<[Quantity]={">0"}>}[Amount])/sum({1}[Quantity])
Try this,
=sum({1<[Quantity]={">0"}>}[Amount])/sum({1}[Quantity])
Remove the Extra {} from expression.
Regards,
Kaushik Solanki