how to get the count of non zero values in a row

Question

Sample Data:

day       employee    expense_reason        expense
2/24/2018   abc   car mileage               $5 
2/24/2018   xyz   car mileage               $5 
2/24/2018   xyz   car rent                  $8 
2/24/2018   xyz   car rent                  $9 

Find all the occasions where single employees have claimed both the expenses on the same day.

I have created the following view in Tableau using day and employees as rows and expense and the reason as column and finally sum(number of rows) on the text of the markscard.

What I am getting is the grand total using analysis>>totals>>show row totals instead of getting row totals, Can anyone help me to get the count of non zero values in a row

                  expense_reason        
day        employee   car mileage   car rent    grand total
2/24/2018   abc         1                         1
2/24/2018   xyz         1           2             3

update 1

I tried this but it is not giving output as I want

Answer 1

In first part you should solve the No-Data part since there is no data for the combo abc-rent.

In order to it you can use the lookup function, and force a fake lookup using 0 as parameter.

LOOKUP(SUM([Something]),0)

Then you can use ZN function and force a zero for a null value, which is different from No Data.

That being said, you should be able to get something like this:

Create this calculated field:

zn(LOOKUP(max({ FIXED [day],[employee],[reason] : COUNT([reason])}),0))

EDIT

If you want to have grand totals, i think this should be the better solution:

And the Calculated Field is a pure Count nested in a lookup function as said before:

zn(LOOKUP(COUNT([expense]),0))