I am trying to count specific values across multiple fields (I want to see achiever to be counted across all five fields if mentioned for the all people), and measure them against a table full of values in a different table below the first table. I have tried concatenating them all and then measuring with a countax containstring(etc) but currently wont let me. Any solutions?
@jbluhm You need MC Aggregations: Multi-Column Aggregations (MC Aggregations) - Microsoft Power BI Community
User | Count |
---|---|
129 | |
63 | |
35 | |
29 | |
26 |
User | Count |
---|---|
144 | |
69 | |
42 | |
41 | |
24 |