Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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")
Solved! Go to 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😅
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.
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.
Hi @santiagomur ,
calculated columns are not dynamic, but are only calculated when loading.
For dynamic calculations, you must use measures.
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
Hi @santiagomur ,
look at this.
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.
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😅
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |