'PowerBI - Amount from multiple columns for one value
I have a list of projects and what Systems they require. Because it is possible for one project to have multiple systems we used multiple columns for this information. Now i want to calculate the amount of "Local Ownerships" in all Columns.
For excample:
| Project Name | System 1 ownership | System 2 ownership | System 3 ownership |
|---|---|---|---|
| Project 1 | Local Ownership | Local Ownership | empty |
| Project 2 | Central Ownership | empty | empty |
| Project 3 | Central Ownerhip | Central Onwnership | Local Ownership |
Local Ownership (#): 3
The values can be either Local Ownership or Central Ownership
Solution 1:[1]
For this Unpivot the table using System columns and get a count on "Local Ownership" or "Central Ownership" columns according to the requirement.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | AmilaMGunawardana |