Forum Discussion

Giavo's avatar
Giavo
Helper III
8 years ago
Solved

SUM inside SWITCH( TRUE()

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

  • 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

1 Reply

  • 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