Forum Discussion

safina03's avatar
safina03
New Member
2 years ago
Solved

Combine Data in One Column

Hi, I have one column that I want to combine 6 types of this except one data and also I want to see the Sum of all of them. I mean like this: 1- Sum 2 Bearbeitet 3-Unbearbeitet = In Bearbeitung...
Need Help
Daniel29195's avatar
Daniel29195
Icon for Community Champion rankCommunity Champion
2 years ago

Hello safina03 

create 3 measures : 
measure 1 = sum(table[column])

 

measure 2 = 

calculate (

sum(tbale[column]) ,

type = "Bearbeitet")

 

measure 3 : 

calculate ( 

sum(table[column]), 

type in {"Bearbeitung", "Zuarbeit ","Zuarbeit erfolg","Zuarbeit zurĂĽckgewiesen","zurĂĽckgewiesen"}
)

 

 

then add the 3 measures in the visual ..

 

 

let me know if this helps achive what you are looking for. 

 

best regards