Forum Discussion
BudMan512
Helper V
Helper VTwo Measures - two different results
Hi All, I am producing a Matrix that shows customer deliveries of fuel for each month of the year. I also have a second page with various tables and graphs including one that sums the gallons...
You could add a measure like this:
Mixed Unit Value = CALCULATE ( [Adj Qty], KEEPFILTERS ( category[CATEGORY] = "01C" ) ) + CALCULATE ( [Gallons], KEEPFILTERS ( category[CATEGORY] <> "01C" ) )It calculates measure [Adj Qty] for category 01C and [Gallons] for all other categories.
Martin_D
Solution Sage
Solution SageYou could add a measure like this:
Mixed Unit Value =
CALCULATE (
[Adj Qty],
KEEPFILTERS ( category[CATEGORY] = "01C" )
) +
CALCULATE (
[Gallons],
KEEPFILTERS ( category[CATEGORY] <> "01C" )
)It calculates measure [Adj Qty] for category 01C and [Gallons] for all other categories.