Remove totals from measures even when only one value is selected

[Anonymous]

Hi there,

I have a measure that i would like to remove totals from. And the common solution I found online is to use HASONEVALUE formula. Which works if there are several rows of data are returned. But this does not work if only one row is returned.

Here is my meaure

Option Description:= IF(HASONEVALUE('Tenant Occupancy'[TenantCode]),IF(NOT ISBLANK(CALCULATE(MAX('dim DimLeaseOption'[OptionTerm]),FILTER('dim DimLeaseOption', RELATED('Tenant'[Tenant Code]) = SELECTEDVALUE('Tenant Occupancy'[TenantCode])),'dim DimLeaseOption'[OptionStatus] = "Active")),CALCULATE(MAX('dim DimLeaseOption'[OptionTerm]) & " months | Description: " & MAX('dim DimLeaseOption'[OptionDescription]) ,FILTER('dim DimLeaseOption', RELATED('Tenant'[Tenant Code]) = SELECTEDVALUE('Tenant Occupancy'[TenantCode])),'dim DimLeaseOption'[OptionStatus] = "Active")))

If only one row is returned in the output total appears, which is what i would like to avoid.

[Ashish_Mathur]

Hi,

Replace HASONEVALUE with HASONEFILTER.

[Anonymous]

Thanks Ashish, but this solution did not work as it is a row level filter. Repalcing has onevalue returns blanks

hasonevalue(tenantcode) - tenantcode here is a row in a table visual.

What else do you reckon we should try?

[Ashish_Mathur]

No idea.  If you can describe the business question, share some data and show the expected output, then i may be able to help.