Forum Discussion
Solved
Division over a SWITCH column
Hello All I am trying to create a division calculation on top a numeric column derived using a switch statement. Codeval = SWITCH('Table'[Index], "1", 1, "2", 1, "3",1, "4",1, 0). "Index" co...
Hi Guavaq,
I tried this following by creating it as a measure as per your ealier suggestion
NewMeasure = Divide(sum(Sumofsales), count(Codeval),0) worked..!
Thank you..!
