To display without aggregation in matrix

[harshagraj]

Hi all i have two tables one has 72000 rows(Date from 01-MAR-2017 to 01-MAR-2019) its Month On Month Data. Table2 has output from software data which just has 24 months(MoM) data and has only two columns date & output. 

Now using matrix i have used table 1 to aggregate all profit and losses for mom.

I need a final output in a matrix as Difference, that will be profit and loss from Table 1 and Output from table 2. I have attached the images.

Eg: (Table 1) April 2017 Profit and loss is -2,59,91,854 and (Table 2) 01 April 2017 As per tally is -1,089,731 i need output as

Difference in the last row of matrix as -2,49,02,123.

[v-chuncz-msft · Accepted solution]

@harshagraj 

You may try ISINSCOPE to change the total.

• https://community.powerbi.com/t5/Desktop/Dynamic-Difference-Measure-Using-Slicer/m-p/590745#M280280
• https://community.powerbi.com/t5/Desktop/Difference-between-two-columns-in-matrix-visualisation/m-p/...