Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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!