Forum Discussion
Solved
HASONEVALUE help
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 be...
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.
