Calculate percentage difference from different table in a Matrix Visual with DAX

[ctmah]

Hi Power BI experts, 

I have this table to be produced in Power BI Visual - Matrix in tabular format

- Month is from Calendar table that links Table Target & Table Actual. 

- Customer is from Customer Master that links to table Target. 

- Table Target contains multiple target rows for each customer and each Brand

- Table Actual contains multiple rows on daily sales volume for each customer and each brand

I'm able to pull the figures together from Table Target & Table Actual however I need the percentage highlighted in yellow to be displayed in the matrix visual as addtional column to each Brand & Total. How to write a DAX snytax to fulfill this requirement?

Many thanks. 

Regards

ctmah

[amitchandak]

@ctmah ,

A new measure like this ?

diff % = divide([Target] -[Actual],[Target])

[ctmah]

Hi @amitchandak , 

I tried writing like this, but doesn't work. 

Measure  = divide(SUM('Target Daily'[Value])-SUM('Current Month Daily Trial'[Order Qantity (litre)]),SUM('Target Daily'[Value]))

regards

ctmah