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! I am new to PowerBI but have been exploring it for a couple months now. I come from Excel and Access and having discovered now PowerBI, I believe I am going to use it more often.
I need to know which and how many items are most used across different projects.
Using "New column" (instead of "New measure"), I have created:
DistinctProjects = CALCULATE ( DISTINCTCOUNT (Table1[Project]); FILTER ( Table1; Table1[ItemNr] = EARLIER(Table1[ItemNr] ) )
When not filtering any of the projects on the slicer "Project", it shows the correct behaviour, i.e. e.g. there are 2 items utilized in 3 different projects. These 2 items are 'Item 01' and 'Item 02'.
That's OK, but when I filter on the slicer for 'Project A' and 'Project B', it does not show the correct statistics, i.e. it should say that only 2 items are utilized in 2 different projects, and not 3 (because it is counting in all the projects universe of Table1 unfiltered).
HELP! I can I make it work?
Thanks for any hint or direction in the right path!
Cheers,
Jorge
Solved! Go to Solution.
Hi @almeidajac,
I'm afraid it is not available to achieve such a requirement. You should be aware that the values resturned by calculated column are static once it is initialized. So, the [DistinctProjects] items displayed in visual won't be dynamically changed based on slicer. However, if you get DistinctProjects via measure, it could be dynamical, but measure will only show one single value in a visual without any context.
Regards,
Yuliana Gu
Hi @almeidajac,
I'm afraid it is not available to achieve such a requirement. You should be aware that the values resturned by calculated column are static once it is initialized. So, the [DistinctProjects] items displayed in visual won't be dynamically changed based on slicer. However, if you get DistinctProjects via measure, it could be dynamical, but measure will only show one single value in a visual without any context.
Regards,
Yuliana Gu
Here's the file I have been using, if it helps.
https://www.dropbox.com/s/smapnmf720hxyoc/Test%20count%20items%20project.pbix?dl=0
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 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |