The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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!
User | Count |
---|---|
65 | |
62 | |
60 | |
53 | |
30 |
User | Count |
---|---|
181 | |
82 | |
67 | |
48 | |
44 |