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,
I have a matrix table where I have created 4 different measures as shown below:
Diff measure = [Second-Update] - [First-Update] and it works correctly in showing row level difference
but the delta column which is equal to DIVIDE([FIrst-Update],[Second-Update]) shows same value across all rows. I want a division of two measures for each row separately. Can anybody suggest what am I missing?
I believe your DAX is correct. I have had similiar issues when attempting to create measures for tables. I have always for a solution around this by, instead, creating calculated columns instead.
Attempt these calculations within the table view, and then pull over the fields to the matrix table.
Let me know if that helps.
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |