Dax Variance and percentage computation code.

[JanCen]

What is the code for these. I want to have. 

1. Variance/ending balance. between Total delivered vs Total Sales 2. Percentage %

 Thank you so much.🙏🏻

[v-binbinyu-msft · Accepted solution]

Hi @JanCen ,

Please try below steps:

1. below is my test table

Table:

2. create measure with below dax formula

Variance =
VAR cur_del =
    SELECTEDVALUE ( 'Table'[Total Delivered] )
VAR cur_sale =
    SELECTEDVALUE ( 'Table'[Total Sales] )
RETURN
    cur_del - cur_sale

% Percent =
VAR _sal =
    SELECTEDVALUE ( 'Table'[Total Sales] )
VAR _del =
    SELECTEDVALUE ( 'Table'[Total Delivered] )
RETURN
    FORMAT ( DIVIDE ( _sal, _del ), "Percent" )

3. add a table visual with fields and measure

Please refer the attached .pbix file.

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.