SUM inside SWITCH( TRUE()

[Giavo]

Hi everybody, i have a Line Chart with the weeks on X Axis and Money on Y Axis.
I am using this formula in order to display different targets for different organizations (5 Orgs) :
SWITCH(TRUE().
                               CONTAINS('Table'.'Table'[Org]."ORG1") .17627254.
                                CONTAINS('Table'.'Table'[Org].ORG2").8397950.
                                CONTAINS('Table'.'Table'[Org]."ORG3").10959546.
                                CONTAINS('Table'.'Table'[Org]."ORG4") .13959546.
                                CONTAINS('Table'.'Table'[Org]."ORG5") .15959546.
                                BLANK()
)

Now, selecting each organization i can see the targets as i defined in the measure. My problem is that when selecting all of the 5 Organizations i would like to see the sum of all this targets. But when i select all 5 organizations i don't see the sum but the value just for the ORG1.

How can i Achieve a result of summing all Targets when all Organizations are selected?

Thank you in Advance
Cheers

[BalaVenuGopal · Accepted solution]

Hi @Giavo ,

Create a measure with sum(targets) and use that mesure in your switch case will resolve  your issue.

Please mark as solution if this works for you otherwise pelease share data