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.
hi,
I have a table, and need to summarize for few key columns:
ProductCategorySales
A | AB | 1 |
B | AB | 2 |
C | AB | 3 |
D | BB | 33 |
E | BB | 4 |
D | BB | 1 |
How can I get the summarize from Product, Category, and an addtional column: count the rows of Category in that summarize table?
Expected output:
CategoryProductCount of Category
AB | A | 3 |
AB | B | 3 |
AB | C | 3 |
BB | D | 2 |
BB | E | 2 |
here is the PBI file:
https://1drv.ms/u/s!Aps8poidQa5zk8N44FWQEfeQbFXbnA?e=Y5tTDh
Thanks
Solved! Go to Solution.
Hi @Iamnvt ,
Try this code:
Hi @Iamnvt ,
Try this code:
@Iamnvt , try a measure like this, you can use this in summarize or summarizecolumns
Measure = calculate(count(Table[Category]),allexcept(Table[Category]))
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 |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |