Forum Discussion
SWITCH Function not giving correct result
Hi,
If you are creating a calculated column (not measure) in the table, please try the below to create a new column.
ProjectCategory = VAR Revenue = XXX[YYY] RETURN SWITCH ( TRUE (), Revenue >= 50, "C", Revenue <= 50, "S" )Anonymous
Thank you for the clarification. Unfortunately it doesn't work like this. You need to create a calculated column as suggested by Jihwan_Kim and then use it to slice you visual. Then you can create a measure such as COUNTROWS ( TableName ) or just drag the Project column in the Values of the visual ans summarize it by count or distinctcount as needed.
Hi Anonymous ,
Please try below steps:
1.Add a new column to table
Project Catagory = SWITCH ( TRUE, 'Table'[Planned Revenue] <= 50, "S", 'Table'[Planned Revenue] > 50, "C" )2.Visualize the data with pie chart
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jihwan_Kim and tamerj1, thank you very much guys for your help. I created a new similar Project without important Data and made some Screenshots to show you 🙂
 
 
 
Anonymous
Thank you for the clarification. Unfortunately it doesn't work like this. You need to create a calculated column as suggested by Jihwan_Kim and then use it to slice you visual. Then you can create a measure such as COUNTROWS ( TableName ) or just drag the Project column in the Values of the visual ans summarize it by count or distinctcount as needed.
Dear tamerj1, I created a calculated column as you and Jihwan_Kim suggested but it still doesnt work. As you can see in every row of this created column is S, even when projects x, c and df > then 50 and belong to C. Do you have any Idea why?
 
Hi Anonymous
Delete SELECTEDVALUE. Just use Table[Column] directly