The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi Folks,
hope I can get some help,
I am working on a item count table that need total count information update daily.
data has multiple Groups ( 99AP, 99BB, 99NN) and sections (AMB,CLD,DRG). looing for solution how to manage desired output in Matrix table with golbal or simple mesure/s
example below table has 3 owners have common areas need to get count of slot per day, previously I am writing measure for owner+ area for this scenario 9 measures and using switch to present out put as shown belwo summary table - is there a way we can write simple measure to cover all - any help appreicated. Thanks V
Date | Owner | Area | Slot No |
18/07/2025 | 99AP | AMB | A1 |
18/07/2025 | 99AP | AMB | A2 |
18/07/2025 | 99AP | AMB | A3 |
18/07/2025 | 99AP | AMB | A4 |
18/07/2025 | 99AP | DRG | A34 |
18/07/2025 | 99AP | CLD | A5 |
18/07/2025 | 99AP | CLD | A6 |
18/07/2025 | 99BB | CLD | A7 |
24/07/2025 | 99BB | DRG | A35 |
18/07/2025 | 99BB | CLD | A8 |
18/07/2025 | 99BB | AMB | A9 |
18/07/2025 | 99BB | AMB | A10 |
18/07/2025 | 99BB | AMB | A11 |
18/07/2025 | 99NN | CLD | A12 |
18/07/2025 | 99NN | AMB | A13 |
18/07/2025 | 99NN | CLD | A14 |
18/07/2025 | 99NN | CLD | A15 |
18/07/2025 | 99NN | CLD | A16 |
24/07/2025 | 99AP | AMB | A1 |
24/07/2025 | 99AP | AMB | A2 |
24/07/2025 | 99AP | AMB | A4 |
24/07/2025 | 99AP | CLD | A5 |
24/07/2025 | 99AP | CLD | A6 |
24/07/2025 | 99BB | CLD | A7 |
24/07/2025 | 99BB | AMB | A9 |
24/07/2025 | 99BB | AMB | A10 |
24/07/2025 | 99BB | AMB | A11 |
24/07/2025 | 99NN | CLD | A12 |
24/07/2025 | 99NN | AMB | A13 |
24/07/2025 | 99NN | CLD | A14 |
24/07/2025 | 99NN | CLD | A15 |
24/07/2025 | 99NN | CLD | A16 |
24/07/2025 | 99NN | CLD | A17 |
24/07/2025 | 99NN | AMB | A18 |
24/07/2025 | 99NN | DRG | A19 |
24/07/2025 | 99NN | DRG | A20 |
24/07/2025 | 99NN | DRG | A21 |
24/07/2025 | 99NN | DRG | A22 |
expected output
Hi @Vemul
@Ashish_Mathur @danextian @rohit1991 @Royel Thanks for your inputs.
I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.
Hi @Vemul
I wanted to check if you had the opportunity to review the information provided by users. Please feel free to contact us if you have any further questions.
Hi @Vemul
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.
@Vemul Let's solve this in two steps
Step 1: Create a measure
Slot Count = COUNTROWS(Data)
Step 2: Create Matrix Visual
Hi @Vemul ,
You don’t need to write separate measures for each owner/area/date combination, Power BI’s Matrix visual is designed for this kind of summary.
Create a simple count measure: RowCount = COUNTROWS(YourTable)
Or, if you need a unique count (like unique owners): OwnerCount = DISTINCTCOUNT(YourTable[Owner])
Set up your Matrix visual. Add your count measure as the Value. Power BI will automatically break out the counts for every combination no need for dozens of separate measures or complex SWITCH statements. The visual’s built-in filtering handles it all.
If you want to filter for special cases (like counting only when another column equals a value), just use CALCULATE to add your condition. For huge datasets, you can pre-aggregate in Power Query if performance ever becomes an issue, but for most cases the Matrix handles this easily.
You should be able to do that with the native matrix viz. Your measure can be as simple as COUNTROWS('table') if you're simply counting the rows or records in a table.
Hi,
Just create a simple matrix visua and drag this measure
Measure = countrows(Data)
Hope this helps.
Hi Ashish,
countrows(data) is givng total row count, but I am looking for count for Owner+Area combination
Thanks
V
Drag owner, area and date to the matrix visual. The measure will read those as implicit filters and return the corect answer.
User | Count |
---|---|
87 | |
84 | |
36 | |
35 | |
32 |
User | Count |
---|---|
96 | |
75 | |
67 | |
52 | |
52 |