How can I remove a total on a date column in table?

[FOXYBARK]

HI there. 

I have the following table shown with these columns. One column is a date column and I'd like to remove the total on the date column only. I did try adjusting the font color to white using the 'Specific Column' option to format. However, that will adjust the other date values in that column as well. I don't want to do that. Any suggestions?

Thanks

[Ashish_Mathur]

Hi,

Assuming End date is a measure that you have written, write this measure

Measure = if(hasonevalue(Data[Furniture]),[End date],blank())

Hope this helps.

[FOXYBARK]

Thanks. The end date is not a created measure. It's an actual column in my data set. 

[Ashish_Mathur · Accepted solution]

Then remove that end date column and drag this measure instead

Edate = max(Data[End date])

Measure = if(hasonevalue(Data[Furniture]),[Endate],blank())

Hope this helps.

[Greg_Deckler]

@FOXYBARK Create a measure that displays the date for individual rows but blank when in the total row. See following information.

First, please vote for this idea: https://community.fabric.microsoft.com/t5/Fabric-Ideas/Matrix-Table-grand-totals-with-Measures/idi-p...

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8