cancel
Showing results for
Did you mean:
New Contributor

## Totals on column is displayed as NaN

I have the following formula which brings me values for each one of the cells but for totals i get NaN value.

How can i make this DAX formula work on column Totals?

```% Cost no MT = IF ( OR(ISBLANK([% Cost]); [% Cost] =0); 0 ; IF(
SUM('Master Table - All Services'[Cost_no_MT]) / SUMX(VALUES(Calculated_Measures[TaskGID]);CALCULATE(SUM('Invoices to Clients'[TurnOver]))) = 0;
SUM('Master Table - All Services'[PONetValue]) / SUMX(VALUES(Calculated_Measures[TaskGID]);CALCULATE(SUM('Invoices to Clients'[TurnOver])));
SUM('Master Table - All Services'[Cost_no_MT]) / SUMX(VALUES(Calculated_Measures[TaskGID]);CALCULATE(SUM('Invoices to Clients'[TurnOver])))
) )```

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: Totals on column is displayed as NaN

It seems the denominator returns 0. But we can't find out why unless we have the data. Can you share a sample? Maybe you can check it out. The context of the Total is the whole parts.

```SUMX (
CALCULATE ( SUM ( 'Invoices to Clients'[TurnOver] ) )
)```

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Super Contributor

## Re: Totals on column is displayed as NaN

It seems the denominator returns 0. But we can't find out why unless we have the data. Can you share a sample? Maybe you can check it out. The context of the Total is the whole parts.

```SUMX (
CALCULATE ( SUM ( 'Invoices to Clients'[TurnOver] ) )
)```

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
New Contributor

## Re: Totals on column is displayed as NaN

Indeed it was the denominator which was returning zero and also i had quite a few NaN values in various cells after the calculation. I fixed them too.

Thanks a lot

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: 80 members 1,307 guests
Recent signins: