Create in lookml a total measure that ignores dimensions

[Rub_moy]

Hi everyone, 
I need to create an measure in lookml that always shows the total value of a field (ie sum(total_amount)), regardless of whether you group by dimensions or not. Basically, I need something that does the same thing than the 'totals' while exploring data:

Is there any way to achieve that in lookml? 

Thanks in advance!

[GavinW]

I don't think this is possible, unfortunately - it works for totals because the totals query is an entirely separate query to the explore query (you will see this in the generated LookML).

What is the end goal that you are looking to achieve, in case there is another solution that could work?

[Rub_moy]

Hi @GavinW ! thanks for your answer.
We are building a model and a dashboard from which users can send data to GCS.
We wanted to create a measure that counts the number of registers and use that measure as a filter in the explore so it doesn't show results when the users requests more than XXX rows.
The problem is that, when we used that measure in a table with multiple dimensions, it creates a group by and there is no way we know the number of rows in total.

[GavinW]

The only thing I can think of right now, if you are creating a dashboard, would be to have a single value visualisation tile that has a warning displayed if users have the dashboard set to pull back too many rows of data (just count the rows and have  a table calculation return an 'ok' or a 'warning' depending on how many rows).

[Rub_moy]

Thats is what we already have with a KPI warning message, but they still could send the request to GCS. Thanks!