Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi,
I have a matrix that I am tracking instances of purchases and deductions by suppliers by period.
What I need to do is to identify an variances by period & by supplier.
E.g. Each Period needs to show by supplier a 0 (Nil), -1, +1 (or some other variable) to identify if the count of purchases match the count of deductions in the file, and ignore any 0 (nil) values.
A sample of what I am looking to get at is below along with a simplified sample database.
(Note, I don't need the Grand Total)
I am new with DAX, and it seems I have hit my mental block with this one 🙄.
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |