Hide the measure total in the report

[BishwaR]

I have created a flag using DAX like Flag= IF(Discount >0,"Y","N") it works fine but at the bottom of the report it gives the Total.

Discount   Flag

2               Y

1               Y

0               N

--------------

Total         Y

I want to hide Y at the bottom by not using the Field Formatting ( selecting font color white and apply to Total)

Thanks

Bishwa

[amitchandak]

@BishwaR , Based on group by of your visual

IF(isinscope(Table[Group]) && Discount >0,"Y","N")

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

or

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

[BishwaR]

Thanks a lot for your feedback. For some reason isinscope did not work for me so I replaced it with HASONEVALUE and it work fine.