Forum Discussion

JosephOutlaw's avatar
JosephOutlaw
Frequent Visitor
9 years ago

Filter a Calculated Measure using a Dax formula

Is there a way to filter a measure using a dax formula?

 

For example in the Dax formula below,

using the  Calculate function I am able to filter a column [INTERACTIONS PREVIOUS MONTH]

 

.Interactions Previous Month(Exclude/LE/Interactions) = CALCULATE(SUM(Query1[INTERACTIONS PREVIOUS MONTH]),FPA_PARENT_USAGE_REVENUE[Exclude] = BLANK(),FPA_USAGE_REVENUE[LE_Version] = "2.0")

 

and this works fine

--------------------------

 

I would like to do the same thing as above but instead use a Measure

 

CALCULATE(SUM( ADD MEASURE HERE),FPA_PARENT_USAGE_REVENUE[Exclude] = BLANK(),FPA_USAGE_REVENUE[LE_Version] = "2.0")

 

I know this is not possible with Calculate function but is there another way to do this with Dax? The goal is to filter the Interactions from the Previous Month. I can get the Previous Month with np by creating a measure. The challenge is filtering that Measure with a Dax formula

9 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    I think that you would create a Measure that did a SUM of what you are trying to sum and then use a CALCULATE to calculate that measure in the context that you are trying to achieve.

    • JosephOutlaw's avatar
      JosephOutlaw
      Frequent Visitor
      9 years ago

      Thanks for the response.... the challenge is the Calculate function only accepts a column, not a measure. Even if I create a measure that did a Sum.... the Calculate function will only take a column not a measure

      • mattbrice's avatar
        mattbrice
        Icon for Solution Sage rankSolution Sage
        9 years ago

        Not sure i undestand what you are referring to.  As Greg_Deckler said, just put your measure in where you highlighted in Black but don't wrap in a "SUM".  The first parameter to CALCULATE is an expresssion which can be a measure as long as it returns a single value.  Are you sure the errror is not becauser of the "SUM" you have in there?  SUM does require a columna reference.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi JosephOutlaw,

     

    Different from calculated column, a measure can only return a single value. But, if adding the measure to visual, for example, table visual, measure can also display value on each row based on current context. So, what is your desired output? Please provide some sample data and illustrate your expected result with some examples.

     

    Best regards,
    Yuliana Gu