Custom Subtotal Issue

[needhelp89]

Hello,

I have am creating a custome subtotal and it is working correctly. However, the rows where I am not specifying a calculation, a total from not sure where is showing up and can't get rid of it. In the below, I do not want the $2,597.57 showing up anywhere, it should  be blank. 

This is the measure I'm using.

[Anonymous]

Hi @needhelp89 ,

I get little information. The solution to the problem should be to control the output by checking the values of the fields on the current row, sort of like this:

measure = 
switch(
selectedvalue('table'[Level 2]),
"Maximum Gross Potential Rent",blank(),
...
...
...
[_Subtotals]
)

Matrix Visual In Power BI: Controling Totals & Subtotals

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly--How to provide sample data in the Power BI Forum--China Power BI User Group