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: | |
4 REPLIES 4
Super User
Super User

Re: DAX - Grand Total shows $0 for measure

Hi @jasonmhg

Could you share the pbix?

Highlighted
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: | |