HASONEVALUE help

[johnmelbourne]

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 · Accepted solution]

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 · Accepted solution]

@johnmelbourne ,

You may use ISINSCOPE.

https://community.powerbi.com/t5/Desktop/Hide-a-total-of-one-of-my-columns-in-a-Matrix-Table/m-p/649...

[d_gosbell · Accepted solution]

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.