Forum Discussion
Helper VHow to handle Total and Grand total Values
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
Hi NadeemAhamed
You can use isinscope function to change the totals .
For examleMore detailed guide is by the link:
https://www.youtube.com/watch?v=xAZY9FyLDPoOr from format options like in the video :
https://www.youtube.com/watch?v=ocbpz2Z_tr8If my answer was helpful please give me a Kudos and accept as a Solution.
2 Replies
- Ritaf1983
Super User
Hi NadeemAhamed
You can use isinscope function to change the totals .
For examleMore detailed guide is by the link:
https://www.youtube.com/watch?v=xAZY9FyLDPoOr from format options like in the video :
https://www.youtube.com/watch?v=ocbpz2Z_tr8If my answer was helpful please give me a Kudos and accept as a Solution.
- dharmendars007
Memorable Member
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
