Allow end user input to calculate values from measures

[Anonymous]

Hello,

I am new to Power BI and feel slightly overwhelmed with the amount of options at my fingertips.

There are two measures I have calculated from separate columns in a table;

1. Measure calculates the average time across a column, and the other does the same for a different set of times.

Time per camera (min)	Time per file (min)
0.1	0.06
0.4	0.08
0.3	0.02

So that I am left with two measures: a. Average Time per Camera (min), and b. Average Time per File (min)

2. I want for an end user to be able to input a parameter for 'how many cameras' and 'how many files' in order to calculate an estimated time using a. * input(value1) & b. * input(value2).

3. Then, I'd like the outputs of each to be displayed and an average between them to be calculated and displayed also.

Please ask me to elaborate if needs be, but I'm hoping someone might be able to point me in the right direction for approaching this problem. Thanks in advance!

[TomMartens · Accepted solution]

Hey @Anonymous ,

unfortunately, Power BI does not support input fields that can be used inside measures.

Fortunately, you can use What-if parameters to accomplish what you are looking for: Use what-if parameters to visualize variables - Power BI | Microsoft Docs

Hopefully, this gets you started and helps to tackle your challenge.

Regards,

Tom

[Anonymous]

This worked perfectly.

As I was able to make a 'What if' parameter for a user-input quantity value.

Then create a new measure which multiplies 'Average Time' by 'Quantity'.

Thank you so much!