Parent and Child Hierarchy in a table

[sid-poly]

I have a table as mentioned below

Project Number	Project Number Copy	Name
P01	1	High Level Project
P01	1.1	Low Level Project
P01	1.2	Medium Level Project
P02	2	Second Project

I need to have a table visual which when filtered with Project Number should only show me Project Names that have project number copy with a decimal (Sub Task). Is there a DAX that can help to formulate this condition?

[tamerj1]

Hi @sid-poly 
Place the following filter measure in the filter pane of the table visual, select "is not blank" and apply the filter.

FilterMeasure =
COUNTROWS (
    FILTER (
        VALUES ( 'Table'[Project Number Copy] ),
        CONTAINSSTRING ( 'Table'[Project Number Copy], "." )
    )
)

[sid-poly]

In that case I can iuse the Project Number Copy as text and Exclude the ones that do not contain "."

What I wanted to know is that any DAX Measure that returns a column which can be used in a table?

[tamerj1 · Accepted solution]

@sid-poly 

ProjectNumber =
MAXX (
    FILTER (
        VALUES ( 'Table'[Project Number Copy] ),
        CONTAINSSTRING ( 'Table'[Project Number Copy], "." )
    ),
    'Table'[Project Number Copy]
)