cancel
Showing results for
Did you mean:
Highlighted
New Member

## Table row conditional Formula

Currently, I have next measure which gives the expected result for  the rows 1801.00 and 0801.00:

"Formula 1"

CALCULATE(IF([Invoiced to date]<[Work Budget];
IF([Invoiced to date]<[Commitments];0;[Commitments]-[Invoiced to date]);
IF(AND([Commitments]<[Work Budget]; [Commitments]< [Invoiced to date]); [Commitments]-[Invoiced to date];MIN([Commitments];MIN([Invoiced to date];[Work Budget]))-( [Invoiced to date])) + [Manual Adjustments]) ;'Project budget lines'[Cost line] IN {"1801.00"; "0801.00"})

However, there's other rows as well, for which the calculation is different:

"Formula 2"
CALCULATE(IF([Invoiced to date]>[Work Budget];
IF([Invoiced to date]>[Commitments];0;[Commitments]-[Invoiced to date]);
IF(AND([Commitments]>[Work Budget]; [Commitments]> [Invoiced to date]); [Commitments]-[Invoiced to date];MAX([Commitments];MAX([Invoiced to date];[Work Budget]))-( [Invoiced to date])) + [Manual Adjustments]) ;'Project budget lines'[Cost line] <> {"1801.00"; "0801.00"})

How to combine these formula's into one measure, resulting in one column:

Row Code    Column A Value
0801.00        " value based on formula 1'
1801.00        "value based on formula 1'
2000.00        " value based on formula 2'
2000.01        " value based on formula 2'
2000.02       " value based on formula 2'
2300.04       " value based on formula 2'

Anxious which PowerBI guru can help me in this!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver III

## Re: Table row conditional Formula

As per need create the that cloumn as measure:

Measure=sum(Project budget lines'[Cost line])

Later

Measure 1= if(Measure in condtion, Formula1, Formula2)

4 REPLIES 4
Highlighted
Resolver III

## Re: Table row conditional Formula

Create a measure as given below:

Measure= if(Project budget lines'[Cost line] IN {"1801.00","0801.00"},Formula1,Formula2)

Highlighted
New Member

## Re: Table row conditional Formula

Hi,

thanks, makes sense, however I cannot select/set the Table field  (Project budget lines'[Cost line] )  in the measure. It's only coming up with other measures, and not with table values?

Highlighted
Resolver III

## Re: Table row conditional Formula

As per need create the that cloumn as measure:

Measure=sum(Project budget lines'[Cost line])

Later

Measure 1= if(Measure in condtion, Formula1, Formula2)

Highlighted
New Member

## Re: Table row conditional Formula

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### July 2020 Community Highlights

Learn about the exciting things that happened in July.

#### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

#### Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors