Forum Discussion

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...

Frequent Visitor

9 years ago

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

Solution Sage

9 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
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
  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.