cancel
Showing results for
Did you mean:
Frequent Visitor

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

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

Hi @eravelo,

Maybe something like this

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

3 REPLIES 3
Super User

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

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

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
Frequent Visitor

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

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?

Super User

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

Hi @eravelo,

Maybe something like this

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

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 6 members 1,010 guests
Recent signins: