Use SETs to compare the same measure with two different versions of filters
Example of 2 measures that each reference different SETs:
- // Sales for the East region.
- IF [Region]="East" AND [Segment Set Measure 1] AND [Category Set Measure 1] THEN
- // All conditions true.
- [Sales]
- ELSE
- 0
- END
- // Sales for the West region.
- IF [Region]="West" AND [Segment Set Measure 2] AND [Category Set Measure 2] THEN
- // All conditions true.
- [Sales]
- ELSE
- 0
- END
Comments
Post a Comment