How to remove Earliest Date in total row?

[Tu-VuongLe]

Hey everyone, 

I'm new to PowerBI and I'm trying only show what is necessary in the total row.

I created a pivot table (Matrix visual) and put the document date, quantity, and score in values.

In the total row, I only want it to show sum of quantity and sum of score, but the date always gives Earliest_Document_Date. There's only one date per document, so it doesn't matter if I use earliest or latest for the data points, but I want to remove it in the total row.

Any help would be appreciated.

Thank you

[AbbasG · Accepted solution]

@Tu-VuongLe Hi, you can create a measure for this (by using hasnovalue function). And then use the measure instead of the actual date.

Here is the sample file of my solution. Hope it helps you to achieve the desired output.

[Anonymous]

Hi, 
I would like some help with this as well. I have a matrix with 3 different rows, which holds a lot of different dates. So I understand that it needs to be for example "earliest" in the subtotal rows but when i + it up I would like to see the unique values for each row, which I don't seem to get. Do you have another way to solve this? I tried your measure and it did not work.

Thank you in advance!

[Tu-VuongLe]

Actually, there's a problem with this solution. It now shows every item data, regardless if it's in the order or not.

This is how it used to be:

With your solutions, it gives me this:

[AbbasG]

Hi you can just put a visual level filter on sum of quantity is not blank.

[Tu-VuongLe]

Oh you're right! I hadn't thought about that.. Thank you