Forum Discussion
Resolver IIWHAT IF DYNAMIC COLUMN
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")
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😅
9 Replies
- mwegener
Most Valuable Professional
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.
santiagomurI 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 ,
calculated columns are not dynamic, but are only calculated when loading.
For dynamic calculations, you must use measures.
V-lianl-msftCommunity Support
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.
