Forum Discussion
Power KPI indicator Index
Hi Yuiitsu
According to your current demand description, I can clearly understand your needs, you need measure to count if margin <95% =1, 95%- 100% =2, > 100% =3 in my data, You can use the Switch function in DAX to create the following metric value:
Arrow = SWITCH( TRUE(), [BU Margin]>=0&&[BU Margin]<=0.95,1, [BU Margin]>0.95&&[BU Margin]<=1,2, [BU Margin]>1,3)Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Yes I know I have to put add a column there so I am asking how to create a calculated column like that....
I do not have a measure to count if margin <95% =1, 95%- 100% =2, > 100% =3 in my data.
This is the measure I am asking for help.
For example the file you ask me to download has this :
KPI Index = if(value([Variance])>= .05, 1, if(value([Variance])<-.05,3,2))
^ so what I am seeking help in is how can I make a measure to add a calculated column giving the specific condition I want the index.
Hi Yuiitsu
According to your current demand description, I can clearly understand your needs, you need measure to count if margin <95% =1, 95%- 100% =2, > 100% =3 in my data, You can use the Switch function in DAX to create the following metric value:
Arrow =
SWITCH(
TRUE(),
[BU Margin]>=0&&[BU Margin]<=0.95,1,
[BU Margin]>0.95&&[BU Margin]<=1,2,
[BU Margin]>1,3)
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly