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!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hello,
I need to create a matrix in power bi using Dax like on the photo that I uploaded.
I have a one-fact table with InvoiceNo, ItemNo, CustomerNo
In rows, I would like to put the number of Invoices that have at least one selected item from the slicer. From 1 to 12, and if we have more than 12, I need to put in >12.
In columns, I have the total number of invoices in 2023. In the same order from 1 to 12 and more than 12 (>12.)
In the intersection of rows and columns, I would put distinct numbers of CustomerNo.
Anybody can help me to write all the required measures?
Hello @sima_ue031 ,
check this to take an idea how you could customise it
https://youtu.be/PI52ckgezzA?si=BLuX6A6YGkny4-p8
https://youtu.be/J4317R5BvsA?si=HbGshy4_X990-Ppk
Proud to be a Super User! | |
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 64 | |
| 53 | |
| 42 | |
| 20 | |
| 17 |
| User | Count |
|---|---|
| 121 | |
| 103 | |
| 46 | |
| 30 | |
| 24 |