cancel
Showing results for
Did you mean:
Regular Visitor

## DAX - Grand Total shows \$0 for measure

Hi Guys,

I need your help with something that goes beyond my comprehension.

I have this DAX measure:

Est. Salary =
VAR MonthEnd =  CALCULATE(SUM(PriorMth[EofMonth]),RELATEDTABLE(PriorMth))
VAR TerminationMonth = MAX('Sal Calc'[EOM_EndDate])
VAR EstimatedSal = SUM('Sal Calc'[Ann.salary])/260*[NetWork]*0.5

Return IF(MonthEnd<=TerminationMonth,EstimatedSal,0)

It returns values in the column but for some reason the grand total shows \$0.

I don't understand why ?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: DAX - Grand Total shows \$0 for measure

Hi @jasonmhg,

In fact, this is a common dax calculation issue on total level, normally it will appears when you use dax formula to calculate or compare with current row contents.

You can take a look at following link to know how to deal with these scenario:

Measure Totals, The Final Word

Regards,
Xiaoxin Sheng

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

For learning resources/Release notes, please visit: | |
4 REPLIES 4
Super User

## Re: DAX - Grand Total shows \$0 for measure

Could you share the pbix?

Regular Visitor

## Re: DAX - Grand Total shows \$0 for measure

I'd rather not.

The numbers in the screenshot are bogus but there is confidential info in the underlying data.

Super User

## Re: DAX - Grand Total shows \$0 for measure

Hi,

Try this measure

=IF(HASONEVALUE(Data[Period]),[Est. Salary],SUMX(SUMMARIZE(VALUES(Data[Period]),[Period],"ABCD",[Est. Salary]),[ABCD]))

Change the underlined portion.

Community Support Team

## Re: DAX - Grand Total shows \$0 for measure

Hi @jasonmhg,

In fact, this is a common dax calculation issue on total level, normally it will appears when you use dax formula to calculate or compare with current row contents.

You can take a look at following link to know how to deal with these scenario:

Measure Totals, The Final Word

Regards,
Xiaoxin Sheng

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

For learning resources/Release notes, please visit: | |

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,003 guests
Recent signins: