How to handle Total and Grand total Values

[NadeemAhamed]

Hi Everyone

I am looking for how to handle the Total and Grand Total values which is coming automatically in Power Bi 

but some times if we have some column is text that also its taking as sum.

Exception :

In Power BI

[dharmendars007]

Hello @NadeemAhamed , 

Since there is no filter context at Total level you see the values showing, Please try the Hasonefilter or Hasonevalue to handle this scenerio, you can try the sample code below by replacing the sctually measure or column names you have.

Remark Measure =
IF(HASONEVALUE(Table[Month]),MAX(Table[Remark]),"N/A")

Sum Measure = 

IF(HASONEVALUE(Table[Month]),Sum(Table[Intrest]),Blank())

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[Ritaf1983 · Accepted solution]

Hi @NadeemAhamed 
You can use isinscope function to change the totals .
For examle

More detailed guide is by the link:
https://www.youtube.com/watch?v=xAZY9FyLDPo

Or from format options like in the video :
https://www.youtube.com/watch?v=ocbpz2Z_tr8

If my answer was helpful please give me a Kudos and accept as a Solution.