Forum Discussion

jkapso751's avatar
jkapso751
Icon for Helper I rankHelper I
3 years ago
Solved

Calculate function not respecting filter

Hi, I'm trying to create a measure (#2) based on another measure (#1). Measure1 = CALCULATE(sum('DATA'[Amount]),'DATA'[Account]="Revenue") Measure2 = CALCULATE([Measure1],'DATA'[Category]="CATEGOR...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi jkapso751 

    please try

    Measure2 =
    CALCULATE (
    [Measure1],
    KEEPFILTERS ( 'DATA'[Category] IN { "CATEGORY1", "CATEGORY2" } )
    )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi jkapso751 

please try

Measure2 =
CALCULATE (
[Measure1],
KEEPFILTERS ( 'DATA'[Category] IN { "CATEGORY1", "CATEGORY2" } )
)