Hi
I have created a sample table using the Dax sample
Sample data = SAMPLE(30, FILTER('Table 1', 'Table 1'[Field] = "Values"),0)
This works fine.
After that I have created a WhatIf Parameter so that i could use it to pull the data to a certain record count.
What if Parameter :
Sample Pull = GENERATESERIES(0, 200, 1)
-> Measure :
Sample Pull Value = SELECTEDVALUE('Sample Pull'[Sample Pull],30)
I have then used the parameter value to generate the sample data.
Sample data = SAMPLE('Sample Pull'[Sample Pull Value], FILTER('Table 1', 'Table 1'[Field] = "Value"),0)
Have also tried the below .
In this example it seems to only pickup the default value from the what if parameter which is in my case 30 as written in the code above.
Sample Agric DDA =
VAR
PULL = 'Sample Pull'[Sample Pull Value]
RETURN
SAMPLE(PULL, FILTER('Table 1', 'Table 1'[Field] = "Value"),0)
In these examples it returns nothing
Sample Agric DDA =
VAR
PULL = VALUE(SELECTEDVALUE('Sample Pull'[Sample Pull]))
RETURN
SAMPLE(PULL, FILTER('Table 1', 'Table 1'[Field] = "Value"),0)
Sample Agric DDA = Sample( VALUE(SELECTEDVALUE('Sample Pull'[Sample Pull])), FILTER('Table 1', 'Table 1'[Field] = "Value"),0)
All I need is to dynamically allow end users to extract however many records they'd like to sample for their puroposes.
