Forum Discussion

JosephOutlaw's avatar
JosephOutlaw
Frequent Visitor
8 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]   .Intera...
JosephOutlaw's avatar
JosephOutlaw
Frequent Visitor
8 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
Solution Sage
8 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.

  • JosephOutlaw's avatar
    JosephOutlaw
    Frequent Visitor
    8 years ago

    Thanks for your reply ... Yes, you are correct, In this case though the  return value is multiple values, not a single one

    • mattbrice's avatar
      mattbrice
      Solution Sage
      8 years ago

      So you are trying to return more than one value from CALCULATE?  You can't.  But you can use CALCULATETABLE - but only inside another measure.  At the end, a measure can only return a scalar value.

      • JosephOutlaw's avatar
        JosephOutlaw
        Frequent Visitor
        8 years ago

        Ok, thats what I thought. I was also looking at using a variable. Are we able to use a Variable with the Calculate function?

        Similar to what I have below or will this too only accept a scalar value? Thanks for your help.

        Var XXX = (ReturnValue,Multilple records)

         

        Return

        CALCULATE( XXX),FPA_PARENT_USAGE_REVENUE[Exclude] = BLANK(),FPA_USAGE_REVENUE[LE_Version] = "2.0")