WHAT IF DYNAMIC COLUMN

[santiagomur]

I need to change ranges dynamically and compare them, the idea is to know what happens if we change the goals, how many people would meet or not. What I am trying to do is use "what if" to change the goals and see what happens.

EXP=IF([SALES]<SELECTEDVALUE([WHATIF1])&&[SALES]>=SELECTEDVALUE([WHATIF2]);"RANGE1";

              IF([SALES]<SELECTEDVALUE([WHATIF3])&&[SALES]>=SELECTEDVALUE([WHATIF4]);"RANGE2";"RANGE3")

[V-lianl-msft]

Hi @santiagomur ,

Using measure may meet your needs.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi @santiagomur ,

could you provide a sample pbix file?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[santiagomur]

I can't but, i can give another example, i need to use the selectedvalue on a calculated column as simple like new

goal=table[sales]*selectedvalue(table_what_If[nowgoal] and see the result per row (table) not as a measure or in a card  

my problem is that when i try the value of the selectedvalue comes as blanck.

[mwegener]

Hi @santiagomur ,

maybe this custom visual will help you ...

https://valq.com/

[mwegener]

Hi @santiagomur ,

calculated columns are not dynamic, but are only calculated when loading.

For dynamic calculations, you must use measures.

[santiagomur]

thnk,  @mwegener 

and you know if it is  way to made a measure using if.

what i need to do is something like this 

whatif selectedvalue

whatif1: 2 whatif2=5  whatif3=10

column1: between 0 and 1 =  level0

column1: between 2 and 4 =  level1

column1: between 5 and 9 = level2

            colmn1    level

emp1       1          

emp2       2

emp3       8

[mwegener]

Hi @santiagomur ,

look at this.

PBIX

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[santiagomur · Accepted solution]

thnk Marcus, @mwegener 

Its perfect just what I needed😀, and if now I want to know how many are 1, 2 or 3 on cards😅

[mwegener]

Count Level 0 = COUNTROWS ( FILTER ( VALUES ( 'Table'[Emp] ), [level] = 0 ) )

If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.