Forum Discussion
Solved
Using calculation groups in a new way
Hello all. I am trying to use calculation groups in a nested sort of way. I am not new to power BI or Dax but I am relatively new to calculation groups. In my data, I have columns that have d...
Glad to hear it works. You can add any column to the matrix rows and the measure Display Amount will slice the amount based on whatever values are in the matrix rows. There's no need to create another table.
I got it working. thank you.. One more follow up to the question. What if I have another row header. so I want the Display Amount to be for each company AND each invoice within that company.. so, the matrix would look like this (see table below). Would I have to create another table with all the invoice numbers?
| company | invoice number | List Price | Discount | Net price |
| A | 1 | (Display Amount) | (Display Amount) | (Display Amount) |
| A | 2 | (Display Amount) | (Display Amount) | (Display Amount) |
| B | 3 | (Display Amount) | (Display Amount) | (Display Amount) |
| B | 4 | (Display Amount) | (Display Amount) | (Display Amount) |
| B | 5 | (Display Amount) | (Display Amount) | (Display Amount) |
Glad to hear it works. You can add any column to the matrix rows and the measure Display Amount will slice the amount based on whatever values are in the matrix rows. There's no need to create another table.