Creating new table based on order lines

[MWMemon]

Hi there,

I am new to PBI and would like tp know how to create table from existing table based on conditions such as , for example from a table such as shown below , i would like to seperate orders with one line and one quantity in one table and orders with two lines in seperate table and so on. 

Will appreciate any guidance. Regards

[MWMemon]

Thanks for your reply but actually I am looking for some thing different. I will try to explain it further.

I hope it is understandable now.

Regards

[mangaus1111]

Hi @MWMemon ,

I think you have to add 'Data'[Applied Quantity] = 1 at the end of the last function in the solution written by @Jihwan_Kim . 

Requirement 1 table =
VAR _ordernumberlist =
    SUMMARIZE (
        FILTER (
            ADDCOLUMNS (
                DISTINCT ( Data[Order Number] ),
                "@countrow", CALCULATE ( COUNTROWS ( Data ) )
            ),
            [@countrow] = 1
        ),
        Data[Order Number]
    )
RETURN
    CALCULATETABLE ( Data, TREATAS ( _ordernumberlist, Data[Order Number] ), 'Data'[Applied Quantity] = 1 )

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim · Accepted solution]

Hi,

Thank you for your feedback.

Please check the below picture and the attached pbix file whether it suits your requirement.

[MWMemon]

Thanks alot. Your solution is 100% what I was looking for. Once again thank you

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.