Hiding Rows for Measure taken in Row

[Anonymous]

HiHiding Rows 

I have two measures Amount and Revenue Percentange, I have taken the measures on rows and dates in columns. Want to display the rev % for the top level only. The problem here now is I want to hide the rows other than for the total in the hierarchy. Could you please help if this is achievable.

Thanks&Regards,
cskoch

[v-yulgu-msft]

Hi @Anonymous,

Please try the method mentioned in below link:

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

Best regards,

Yuliana Gu