topic Re: HASONEVALUE help in Desktop

HASONEVALUE help

johnmelbourne — Thu, 02 May 2019 07:05:14 GMT

Hi,

This appears to be a common issue but I can't solve it myself. The syntax is killing me.

I want to hide the total in a table.

I understand you can use the HASONEVALUE function, but it is beyond me at the moment.

My measure is

AverageDaysToResolve_KM = sum(Data[AverageDaysToResolve])

How can i use HASONEVALUE to hide the total in my table?

Any assistance appreciated.

Thanks

d_gosbell — Thu, 02 May 2019 08:24:41 GMT

The use of HASONEVALUE (or ISFILTERED) would require you to reference the column on the rows that the measure is grouped by (see https://powerpivotpro.com/2013/03/isfiltered-a-better-way-to-detect-totals/)

But possibly a simpler solution would be to just turn off the totals for that table.

v-chuncz-msft — Fri, 03 May 2019 04:28:40 GMT

You may use ISINSCOPE.