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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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! | |
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 151 | |
| 130 | |
| 109 | |
| 79 | |
| 54 |