Forum Discussion

efstel's avatar
efstel
Icon for Helper I rankHelper I
2 years ago
Solved

How do I Slice and avoid filtering a measured value?

I have a spread of amounts that are allocated over four areas plus an amount that is not allocated to an area. I have taken that unallocated amount and spread it proportionally over the other areas u...
  • efstel's avatar
    efstel
    2 years ago

    I figured this out... Rather simple fix. Instead of FILTER(ALLSELECTED(OfficeTable) it needed to be FILTER(ALL(OfficeTable).

    Measure 1ALL =
    VAR _unallocated_ = CALCULATE(SUM(OverheadTable[OverheadAmount]), FILTER(ALL(OfficeTable), 'OfficeTable'[Office] = BLANK()))
    VAR _officename_ = SELECTEDVALUE(OfficeTable[Office])
    VAR _prop_ = [%BilledAmounttoOffice]
    RETURN IF(_officename_ = BLANK(), _unallocated_, _unallocated_ * _prop_)

     

efstel's avatar
efstel
Icon for Helper I rankHelper I
2 years ago

I figured this out... Rather simple fix. Instead of FILTER(ALLSELECTED(OfficeTable) it needed to be FILTER(ALL(OfficeTable).

Measure 1ALL =
VAR _unallocated_ = CALCULATE(SUM(OverheadTable[OverheadAmount]), FILTER(ALL(OfficeTable), 'OfficeTable'[Office] = BLANK()))
VAR _officename_ = SELECTEDVALUE(OfficeTable[Office])
VAR _prop_ = [%BilledAmounttoOffice]
RETURN IF(_officename_ = BLANK(), _unallocated_, _unallocated_ * _prop_)