Reply
Regular Visitor
Posts: 15
Registered: ‎01-05-2018
Accepted Solution

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

 

 

 

 

 

 

 


Accepted Solutions
Community Support Team
Posts: 7,219
Registered: ‎08-14-2016

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


All Replies
AlB Super Contributor
Super Contributor
Posts: 839
Registered: ‎11-12-2018

Re: DAX - Grand Total shows $0 for measure

Hi @jasonmhg

Could you share the pbix?

Highlighted
Regular Visitor
Posts: 15
Registered: ‎01-05-2018

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
Posts: 3,748
Registered: ‎01-14-2017

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
Posts: 7,219
Registered: ‎08-14-2016

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