Building a Specific Matrix Table

Hi Anonymous ,

Create the following measures:

Actuals Value = SUM(Actuals[Transaction Amount])

Budget Total = if (HASONEVALUE(Actuals[Month]);BLANK();SUM(Budget[Budget]))

Remaining = IF([Budget Total] = BLANK();BLANK();[Budget Total] - Budget[Actuals Value])

Then add the values on a matrix table:

• Rows: Budget[Name]
• Columns: [Actuals Month]
• Values:
  • Actuals Value
  • Budget Value
  • Remaining

This will give the table below:

Has you can see the Budget Total and reaming columns are blank on the values just resize those columns until they are not visible and be sure to turn off wrap text on  the options:

The months are not in the correct order because is just a mockup. See attach PBIX file.

Regards,

MFelix