if i would like to create a measure to show just sub category "Art" sales number ignoring the rest of the other sub categories,
i created this
FIXED [Sub-Category]="Art" : SUM([Sales])
However when this measure is pulled into view, the rest of the sub categories are also showing numbers. I only want to see Art. Note that i do not want to use Filters.
any help is greatly appreciated .