cancel
Showing results for
Did you mean:
Frequent Visitor

## IF condition in Grand Total

Hi to all,

i have a question about a measure to calculate grand total with particular condition.

I have 3 columns A, B and C

I want insert this condition:

IF A+B > C then A+B else 0

This formula work correclty in the table rows but not work in Grand Total .

May you help me to solved this issue?

Franco

1 ACCEPTED SOLUTION

Accepted Solutions
Member

## Re: IF condition in Grand Total

You can create a new measure (not column) using DAX as follows:

`Measure = IF(SUM(Data[A])+SUM(Data[B])>SUM(Data[C]);SUM(Data[A])+SUM(Data[B]);0)`
Member

## Re: IF condition in Grand Total

You can create a new measure (not column) using DAX as follows:

`Measure = IF(SUM(Data[A])+SUM(Data[B])>SUM(Data[C]);SUM(Data[A])+SUM(Data[B]);0)`

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: 491 members 4,053 guests
Recent signins: