Total Row -Very simple stuff but I am struggling.

[bklyn3]

Hello

I have a Matrix in powerBI desktop. . I would like the total row to show the count. 

Date	Stuff
1/1	ABC
1/2	ABC
2/1
2/3	ABC
Total	3

How do I do that ? 

Somehow it keeps showing ABC

Thank you

[bklyn3]

Hello VahidDM,

I tried to create a measure using the formula you suggested. Then use that measure in a matrix in the "Values" field and turned on the "Row Subtotals" but I still get "ABC" for the total :(. What am i missing ? 
would you mind sharing the .pbix you used above

Thanks for your help.

[VahidDM · Accepted solution]

Hi @bklyn3 

Try this measure:

Stuff Measure =
IF (
    HASONEVALUE ( 'Table'[Stuff] ),
    MAX ( 'Table'[Stuff] ),
    CALCULATE (
        COUNTA ( 'Table'[Stuff] ),
        REMOVEFILTERS ( 'Table'[Date] ),
        'Table'[Stuff] <> BLANK ()
    )
)

output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

 FIFA World Cup - Medal Records