Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to 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
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
87 | |
67 | |
49 |
User | Count |
---|---|
135 | |
112 | |
100 | |
68 | |
67 |