How can i use values from a calculted column in a new measure with the if function?

[eravelo]

As i said, i need to stablish an if function but using an calculated column as a reference, do you know how to do it?

[TomMartens]

Hey,

I'm not sure if I'm missing something, but if you created a Calculated Column in a table you can reference this column from a measure like so:

New Measure = 
IF(SUM('thetable'[calculated column]) < 1000
,666
,42
)

If you want to create a measure, it doesn't matter if the column is calculated or not.

Hopefully this is of some help

Regards

Tom

[eravelo]

Yes but the calculated colum shows values as true or false... what i want to do is this: If (calculatedcolumnvalue = true; calculateoperation; blank)

Is there any function I could use instead of sum for text values? 

[Ashish_Mathur · Accepted solution]

Hi @eravelo,

Maybe something like this

=CALCULATE(your_formula,Data[column1]=TRUE)