Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |