Power Platform Community Forum Thread Details

i have a query against a dataset.

i use a table where each username has a value

example

user1 has 100

user 2 has 200

those numbers will be used to filter using topn in the query against a dataset so user 1 can export only 100 rows.

my measure in pb desktop is

Measure 3 = CALCULATE(MAX('Table (2)'[maxout]),'Table (2)'[user]=USERNAME())

using in a visual seems to work

how can i take this value (100 for example and use it inside the query?

VAR __DS0PrimaryWindowed =
TOPN(10000, __DS0Core, [Measure], 1, 'Cst'[Customer_id], 1)

where 10000 must be dynamic

the columns with the numbers (100,200) ,made it string

Categories:

get value of measure to use in top n in a run a query against a dataset