Combine Data in One Column

[safina03]

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 + In Zuarbeit + Unbearbeitet + Zuarbeit erfolgt + Zuarbeit zurückgewiesen + zurückgewiesen

I try to combine all of thes with using " IF Conditional " , but it is not possible to see the "Sum".

and after that I want to use it like this

[Daniel29195]

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

[lbendlin]

Repeating the same data in the same chart is a design red flag.

[zenisekd · Accepted solution]

@safina03  Please refere to this solution. 
https://community.fabric.microsoft.com/t5/Desktop/Add-total-bar-to-bars-in-clustered-column-chart/m-...

Kudos and mark as solution appreciated 🙂