Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have an important performance using a what-if parameter. The formula below works reasonably well considering that the LLAMADAS table have millions of rows:
Actually I am using the parameter threshold Value:
I have tested using MAX('Min Llamadas Atendidas'[Min Llamadas Atendidas]) but It doesn't work:
Using the fixed threshold It works ok:
Hi,
Could you please click to see the detail of the error? This helps to understand what is not properly configured.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Insufficient resources... but I am using a direct query source.
Hi, I am not sure your how your parameter table looks like, but I try to create a numeric range parameter like below.
It shows that the measure that automatically created is described with the word "Value".
For the VAR inside the measure you created, please try use the measure directly or use MAX DAX function with the column.
Something like the below picture.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |