Forum Discussion

Blinding1's avatar
Blinding1
Regular Visitor
7 years ago
Solved

How To Identify Grand Total Column - Similar to Hasonevalue - But Also When Only One Category

Hi guys, I read that to identify the grand total column we can use Hasonevalue on the category field, however, this doesnt work if my categories are filtered to only one category. Any idea how to ac...
Need Help
Blinding1's avatar
Blinding1
Regular Visitor
7 years ago

Thanks for that formula - it might well do the trick. At the moment my working is in Excel PowerPivot which doesnt support this ISINSCOPE function, but I will try it in powerbi and see if it works. 

 

Kind of weird why it is availble in power bi  but not Excel (yet)

 

Thanks