Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
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 ,
maybe this custom visual will help you ...
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
Hi @santiagomur ,
calculated columns are not dynamic, but are only calculated when loading.
For dynamic calculations, you must use measures.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
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.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
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.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
104 | |
97 | |
39 | |
30 |