Forum Discussion
Solved
split column values based on category
I have a column called Category which has values like: 'Refill On Time Percentage' and 'Refill Volume' and another column called value which gives values in decimal like 0.78 for Refill on Time Pe...
rocku2008_1985 Try:
Measure 1 = SUMX(FILTER('Table',[Category] = "Refill On Time Percentage",[Value]) Measure 2 = SUMX(FILTER('Table',[Category] = "Refill Volume",[Value])Greg_Deckler : Thank You!
Greg_Deckler : Thank You!