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.
I want to create a measure that will calculate the column total of a matrix
MonthYear | Jan-22 | Jan-22 | Feb-22 | Feb-22 | Mar-22 | Mar-22 |
Item | Item Count | Total Item Count | Item Count | Total Item Count | Item Count | Total Item Count |
Top | 5 | 17 | 3 | 14 | 2 | 20 |
Jean | 4 | 17 | 3 | 14 | 2 | 20 |
Hat | 5 | 17 | 2 | 14 | 9 | 20 |
Skirt | 3 | 17 | 6 | 14 | 7 | 20 |
For example, table above shows different clothing items and the number of those items sold each month (the Item Count). I want to create a measure that will show the total number of all clothing items sold each month (Total Item Count) - I know that I can turn on the total row but that isn't what I'm after.
Thanks in advance
Solved! Go to Solution.
Try:
Total item count = CALCULATE(COUNT(Table[Item]), ALL(Table[Item]))
Proud to be a Super User!
Paul on Linkedin.
Try:
Total item count = CALCULATE(COUNT(Table[Item]), ALL(Table[Item]))
Proud to be a Super User!
Paul on Linkedin.
Thank you!
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |