Subnets we are not using

[amoshier]

Sorry but i'm not even sure how to start...  I want to find out what subnets we are not using.   As an example see below.   We have some subnets that we are using and the whole /24 of what would be availble.   Now I want to know what is left from the /24 that we are not using.   

Any suggestions would be appreciated! 

Using

Owned

[Anonymous]

Hi @amoshier 

Maybe you can try Except() function:

Here is a sample:

Then i add a new table:

Table 2 =
EXCEPT (
    SELECTCOLUMNS ( 'Table', "Owned", 'Table'[AA] ),
    SELECTCOLUMNS ( 'Table (2)', "All", 'Table (2)'[BB] )
)

This dax can remove duplicate values from the second table and the first table, so the result is as follow:

Here is the link for your reference:

EXCEPT function (DAX) - DAX | Microsoft Learn

If the above one can't help you, could you please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

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

[ryan_mayu]

what's the expected output ?

[amoshier]

I'm sure the use of this will expand... But my current plans are one a nice design with all our subents by VLAN.  But I would also like a report by VLAN of what subnets are not in use.  So If i'm looking at the example I gave above I own 10.1.10.0/24 (Owned) but i'm only subents i'm currently using are listed in the other table(Using).   I want to know what subnets I have availble/have not used.  

It should tell me that I have not used 10.1.10.64/27