Forum Discussion
Directquery limitation summarize
Hi, Context: I have a table with 7 billion rows in bigquery, the table is partitioned and clustered and performs well when sending queries. I'm trying to get the number of unique users based...
Hi jaime_parra
try without variables
light_users =
COUNTROWS (
FILTER (
SUMMARIZE (
Cancels,
canales[users],
"@avg_trx", AVERAGE ( canales[transactions] )
),
[@avg_trx] >= 15
&& [@avg_trx] <= 25
)
)
Hi tamerj1
I told you that I did the test with the DAX you sent me and it still generates the same in the data source. So the problem persists.