Forum Discussion
Measure based on Field value
I have two measure Total-1 and Total-2. I have a field called Stores which have texts like: "Red","Blue","Pink"...... I want to create a Measure in such a way that Total = Total-1 when [Stores]...
Anonymous add new measure like this and now put stores and new total measure in a table visual and you will get the expected result.
Total = IF( MAX(Table[Stores])="Red", [Total-1], [Total-2])
Anonymous add new measure like this and now put stores and new total measure in a table visual and you will get the expected result.
Total = IF( MAX(Table[Stores])="Red", [Total-1], [Total-2])