Percentage of column 1 when numerator is in column 2

[Anonymous]

Still learning DAX - I have created a matrix from two tables that are really one, I just filtered one table to show RRO Orders only.   The second table has ALL orders (Non RRO orders and RRO orders) - The Orders field has a flag that has a True, False for RRO Orders.   The columns are parsed out by month (CustOrdMonthNum)

I want to find out the percentage of RRO Orders (column 2) from the Total Orders and show this in the matrix or show in a second matrix.   Is this possible?  

[Anonymous · Accepted solution]

@Anonymous

You only need table 2 data where all orders exist RPO & NON RPO

% RPO =
VAR AllOrders = CALCULATE(COUNT(Table2[Order Number]))
VAR RPOOrders = CALCULATE(COUNT(Table2[Order Number]), FILTER(Table2, Table2[RPO]=TRUE()))
RETURN DIVIDE(RPOOrders,AllOrders,0)