Show only total of value in matrix

[CUDataArchitect]

I am attempting to create a matrix in PowerBI that looks like this:

	Processing	Pass-through
Credit	$50,901.00	$17,181.34
Debit	$131,407.93	$5,233.97
Debit PIN	$7,762.92	$4,559.86
Total	$190,071.85	$26,975.17
Over Term	$11,404,311.00	$1,618,510.20

The "Over Term"  is a calculation of the total amount x the term (60). How can I get the "Over term" to show only as a total and not an individual row or column as shown below?

I want the total "Over Term" to stay but not each individual row. The individual rows should only be the net amount.

Please help! This is driving me insane. 

[Ashish_Mathur]

Hi,

Try this

=IF(HASONEVALUE(Data[TypeCategory]),BLANK(),[your measure])

If this does not work, then share the link from where i can download your PBI file.

[CUDataArchitect]

Thank you for your assistance @Ashish_Mathur! That helped since now the only value that is displayed is exactly where I want it ... but the "Over Term" is still displayed in each row and the "Net Amount" amounts that I DO want to show in each row are not just showing directly in their category, but as a separate column within each category and titled as "net amount"

Is there a way to not have the entire row displayed if the value is blank? I attempted to use the matrix filter as the image shows but it did not affect the appearance at all.  The next image shows how to matrix is currently displaying. As you can see - the suggestion successfully removed the unwanted values. But I would also like to remove the unwanted rows but retain the total value of the "over term" at the bottom as it is. 

  

This is my desired outputThis last image is a quick and choppy alteration to show what I would like the matrix to look like. This is the desired result that I have not been successful in creating within Power BI. 

How can I get my matrix to look like the desired output?

[Ashish_Mathur]

Hi,

As i had requested in my earlier post, share the link from where i can download your PBI file.

[CUDataArchitect]

I'm working in the desktop version of PowerBI so my PBI is saved on my computer. There is no option to attach a file to this response. Do you have a site I could drop the file into?

[Ashish_Mathur]

Hi,

Try Google Drive.

[CUDataArchitect]

Thanks

https://drive.google.com/open?id=11b4WpLSpt1C9gORnmvnPBS4YVYsKc0IW

[Ashish_Mathur]

Hi,

I've tried but cannot make it work.  Sorry.

[CUDataArchitect]

Thanks for trying!