Forum Discussion
Conditional Column on Live Connection
Hello all I am using a live connection(Direct Query Mode) I have a Measure I,e Skill Index = DIVIDE(AVERAGE('SA USER_RATING'[Final_User_Rating]), AVERAGE('SA USER_RATING'[MANAGER_EXPECTATIONS]) ...
Hi harshagraj ,
Try this:
1. Enter data to create a Critical table.
2. Create a measure.
Measure =
VAR Critical_ =
IF ( [Skill Index] <= 0.5, "Critical", "Not Critical" )
RETURN
IF ( MAX ( Critical[Column1] ) = Critical_, [Skill Index] )
3. Create a Stacked column chart.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Icey thank you for the reply! It is working but I need to achieve this like in the below image.
The above one i did it in Extract mode. There i could able to achieve in Column.
Below are the formulas i have used.
[Measure] User & Comp LOD =
CALCULATE([Skill Index],
ALLEXCEPT('SA USER_RATING','SA USER_RATING'[COMPETENCY_L1_NAME],'SA USER_RATING'[USER_DN]))
LOD to be applied on Competency L1 and User_DN.
[Measure] Skill Flag_ =
var critical_=
CALCULATE(IF([User & Comp LOD]>=0 && 'SA USER_RATING'[User & Comp LOD]<=0.4,"Far",
IF([User & Comp LOD]>0.4 && [User & Comp LOD]<=0.7,"Below",
IF([User & Comp LOD]>0.7 && [User & Comp LOD]<1,"Achievers",
IF([User & Comp LOD]>=1,"Star")))),ALLEXCEPT('SA USER_RATING','SA USER_RATING'[COMPETENCY_L1_NAME],'SA USER_RATING'[USER_DN]))
Return
IF(MAX('Table'[Column1])=critical_,'SA USER_RATING'[User & Comp LOD])
Hi harshagraj ,
Sorry to reply late.
I'm afraid that my method will not meet your needs.
Best Regards,
Icey