Difference in Matrix visual

[sabeensp]

Hello,

I have a table called TABLE1 as shown below. I have created 2 measurres

1- CALCULATE(SUM(TABLE1[VALUE), FILETER(Table1, TABLE1[Categorey = "A"))
2- CALCULATE(SUM(TABLE1[VALUE), FILETER(Table1, TABLE1[Categorey = "B"))

I brought Matrix visual as shown below, but now I need to show the differnce between Sales and value at the row level, I created another measure Difference = Measurre 1 - Measuer 2, but if I drag that into visual, it appears as a row.

Thanks

[Greg_Deckler]

I'm not sure I'm following this. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[v-yiruan-msft]

Hi @sabeensp ,

Is there an one-to-one correspondence between sales and target value of your source data ? For example , 100 for sale correspond to target 30 , 150 for sales corresponds to target 35 and 200 for sales corresponds to target 40 ? If yes , you can process it on the source data side , and pivot the sales value and target values into 2 columns as shown in the following figure . You can view my shared sample file for details .

Process data in source sideTransform data in Query Editor

Best Regards

Rena

[sabeensp]

@v-yiruan-msftNo there is no 1:1 relationship not all forecast will have sales and vise versa.

[v-yiruan-msft · Accepted solution]

Hi @sabeensp ,

Whether is there any other field that can judge the relationship between sales and target value, such as date field? If no, you may get only one row with summarized value finally.

Best Regards

Rena