Calculate %

[AnjaliBJ]

Hi all,

I have a DAX question and hope that someone can help me out.

I have filtered on status: “00 – Tech OPS” that has 2227 orders in total. As you can see in the picture below 2160 of those orders go to the next status “01 – O2C controle”, 17 orders to “VBD Order Check” and 50 orders to “VBD Order Check na afkeuring”.

I want to calculate the % of how many of the orders are going to the next status.
For “01 – O2C controle” should that be: (2160/ 2227 x 100) 96,99%
For “VBD Order Check”: (17/ 2227 x 100) 0,76%
For “VBD Order Check na afkeuring”: (50/ 2227 x 100) 2,25%

Thank you in advance.

[Anonymous]

Measure = 
VAR Total = CALCULATE(SUM(Data[Aantal Orders]),ALLEXCEPT(Data,Data[Status_id]))
VAR NextStatus = CALCULATE(SUM(Data[Aantal Orders]),ALLEXCEPT(Data,Data[Next_status_id]))
RETURN DIVIDE(NextStatus,Total,0)