Forum Discussion
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 beyond me at the moment.
My measure is
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.
2 Replies
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.