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 work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast
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 work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast
Hi @santiagomur ,
calculated columns are not dynamic, but are only calculated when loading.
For dynamic calculations, you must use measures.
Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast
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 work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast
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 work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast
User | Count |
---|---|
106 | |
82 | |
73 | |
48 | |
48 |
User | Count |
---|---|
157 | |
89 | |
81 | |
69 | |
67 |