Add Calculated Measure to a Matrix

[Anonymous]

Hello! 

This might be simple but i cant figure out how to do it and i might be overcomplicating things:
i have a matrix in which rows are lets say names and the columns are the months of the year and the values being the budget.
And i want to display next to the years only 2 calculated measures (one column) one YTD which sums only the selected months on the slicer and YTG that subtracts the total of all months indiferent to what is filtered in months slicer minus the YTD. 

I have no problem with creating the measures, what im struggling is to put these measures next to the table, because if i drag the measure to Values it will create a column for this measure for every month and if i drag it to columns it doesnt show.

So i want the matrix to look like this, having all months as column and next to it only one column for each calculated measure. Is this possible?

[Anonymous]

Hi @Anonymous ,

Currently Power BI can't do this directly, it requires a change in the modeling aspect.

Please try below steps:

1. create a one column table that include Jan - Dec months and Total, YTD, YTG, like below:

Table:

2. create measure for Total, YTD and YTG

3. add matrix visual, add Table field to column, add name field to row 

4. create a measure that according to the matrix context to calculate the value dynamically and add it to the matrix value

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.