When adding column with switch, he multiplies rows

[Daniel_Fdrvc]

Hi all,

need some guidance… I have created a table with two columns: one is Branch ID and second is a measure Total_points = SUM(taskai[Final_points]) which sum all points in all branches. Now i need to add another column which shows me value based on measure Total_points. I think SWITCH function should solve my problem. So I have created new column with Bonus = SWITCH(TRUE(),[Total_points]>1,100,50), but when I add this column to visualization he expand my table and shows multiple rows of same branch, but with different Total_points. What Imdoing wrong? Final result should be: one branch id, one total point row and one bonus row for summed total points.

 

[v-cazheng-msft]

Hi, @Daniel_Fdrvc 

Is “SV ID” in the first picture equal to “Branch ID”? Can you provide a sample removing sensitive data or describe the situation of the tables in your model in more detail?

Best Regards,

Caiyun Zheng

[amitchandak · Accepted solution]

@Daniel_Fdrvc , I doubt you created a new column. Create as new measure

Bonus = SWITCH(TRUE(),[Total_points]>1,100,50)