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.
Hello to all
I have a perfectly graphic that show all the values sum by project, but in two project I need to show the break down in the graph.
This can be done by using a measure that adds only values in a specific filter?
Any help would be necessary.
Thanks
Are the two projects' names/id static? If so, you could add a FILTER() arguement to your measure where Table[Column] = "Project Name" and then have your customized measure.
If your measure needs to be dynamic and only apply this filter to the specific projects, you could use a SWITCH() or IF() statement to identify when the Project Name is present in the row level context and then it would apply the calculation from above using the Filter arguement.
If you provide sample data it would be easier to answer.
I have something like:
Table 1
IdActivity Project
1 P1
2 P1
3 P2
4 P2
5 P2
6 P3
Table 2
Id IdActivity Value Person
1 1 20 1
2 1 25 2
2 2 20 2
2 3 5 3
2 1 25 4
What I need to to add the Value for the activities of P2 but show the rest of the activities separated.
I tried a FILTER has you suggested but.. It gives me no value. This could be because I'm filtering using table 1 on a measure on table 2.. (it seems dumb I know... )
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |