Forum Discussion
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
- BalaVenuGopalResolver I
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