cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jasonmhg Regular Visitor
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 ?

 

Could you please help ?

 

DAX Measure.PNG

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
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: | |

View solution in original post

4 REPLIES 4
Super User
Super User

Re: DAX - Grand Total shows $0 for measure

Hi @jasonmhg

Could you share the pbix?

jasonmhg Regular Visitor
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
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
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: | |

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

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

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

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.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

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

Users Online
Currently online: 6 members 1,003 guests
Please welcome our newest community members: