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]   .Intera...
JosephOutlaw's avatar
JosephOutlaw
Frequent Visitor
9 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")

mattbrice's avatar
mattbrice
Solution Sage
9 years ago
JosephOutlaw wrote:

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")

Yes, Variables can hold the result of measure and also can hold the results of a table expression.  But just splitting up the formula using variables is not going to change what CALCULATE can do.  CALCULATE can only return a single value.

So I am just not clear on what you are trying to do.  It is best if you post some sample data and the results you are wanting.