topic Re: Allow audience introduce goal manually for any measure they select in DAX Commands and Tips

Allow audience introduce goal manually for any measure they select

perezco — Tue, 28 Apr 2020 16:18:43 GMT

Does exists a way to manually enter a goal in power bi? where the audience can introduce the value. I am not a frequent user of Dax but I will apreciate some guide if this can be achieve or it need to be done under very specific Power bi feature.

I am looking to do under power bi desktop.

The external measure goal introduce may vary depending the type of goal cuz could be in percentage or integer number format.

thanks in advance

Re: Allow audience introduce goal manually for any measure they select

camargos88 — Tue, 28 Apr 2020 16:36:00 GMT

Hi perezco ,

You can use What-IF parameter for that, check this link:

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Ricardo

Re: Allow audience introduce goal manually for any measure they select

perezco — Tue, 28 Apr 2020 23:58:07 GMT

Thanks camargos88 ,
I did for one Measure using the What-IF parameter in a Calculate Measure.

But I am not sure this can be done for several Measures (KPI alias Measure).

Is What-IF parameter the only function tthat Power BI ?

This is what I am trying...

This what I have for one measure. ( I have also measure that are precentage value).

I am aware I cannot create a dynamic calculated column based on what-if parameter.

Re: Allow audience introduce goal manually for any measure they select

camargos88 — Wed, 29 Apr 2020 00:08:01 GMT

Hi perezco ,

What are you trying to do ? I've used what-if as dynamic parameter, it works very well.

Give us more detail about your requirements.

Ricardo

Re: Allow audience introduce goal manually for any measure they select

perezco — Wed, 29 Apr 2020 00:21:43 GMT

Allow the audience Introduce goals for different KPI.

So IF I have 5 kpi it will means 5 different goals.
not sure this will work

Re: Allow audience introduce goal manually for any measure they select

camargos88 — Wed, 29 Apr 2020 00:58:26 GMT

perezco ,

I did the same thing before!!

I had to add 3 what ifs for distinct goals.

Ricardo

Re: Allow audience introduce goal manually for any measure they select

perezco — Wed, 29 Apr 2020 01:32:14 GMT

Does you audience accept the solution of three what ifs for distinct goals?
Did you include dynamic kpi in those three distinct goals for "what if" function?

Re: Allow audience introduce goal manually for any measure they select

camargos88 — Wed, 29 Apr 2020 01:31:33 GMT

perezco ,

Yes, the inputs were about target sales for product groups. Each product group had a target sales and they could simulate the sales and income salary based on range of values.

Ricardo

Re: Allow audience introduce goal manually for any measure they select

perezco — Wed, 29 Apr 2020 01:36:07 GMT

I mean.. Is possible include dynamic kpi inside of each individually to each distinct goals for "what if" function?

Re: Allow audience introduce goal manually for any measure they select

camargos88 — Wed, 29 Apr 2020 04:41:02 GMT

perezco ,

It's possible to compose the kpi, the user will input the scenario and the measure gets the value and returnes the result.

Ricardo

Re: Allow audience introduce goal manually for any measure they select

perezco — Wed, 29 Apr 2020 16:54:15 GMT

thanks camargos88 ... I included the dynamic measure.. work perferct 🙂