Forum Discussion
Incorrect Status based on Minimum value
Hi all, Am stuck in a situation that I cant seem to solve, still learning so would appreciate if you could tell me what am I doing wrong and how do I get this right? It seems simple, but not for me ...
If you have a measure and a calculated column here (which I think you do), the column will be static from the moment it is created. The measure will change according to context. I think that you want the Status to reflect changes in the measure (which it can't currently do).
There are two approaches: Make all features you require 'calculated columns' i.e. Min Price Per Store, Min Price Per City, Status v. Price Per Store, Status v. Price Per City. You'll have to go this way if you want to put any of the Status fields in a slicer.
OR
Make the two fields that you created both measures.
Thank you so much HotChilli! I will give this a shot when i reach home and will keep you posted on how I go.
