Also want a child - Project No's in Grid, for every selected parent's Project No.

[jay_patel]

hello All

Here I am facing an issue, as client want's to display child's projects number also in grid. And the slicer only having parent's Project No.

For ex if i am selecting '0003-03' project no . then the grid also should display project no's ('0003-01-01','0003-01-02','0003-01-03'),for your refrence also attaching an image.

[v-xulin-mstf · Accepted solution]

Hi @jay_patel,

You need create a calculated table as:

Slice_table = 
VALUES('Table'[Project No.])

Create a measure as:

Measure = 
var _len=LEN(MAX('Slice_table'[Project No.]))
var _len1=LEN(MAX('Table'[Project No.]))
return
IF(
    _len<=_len1,
    IF(LEFT(MAX('Table'[Project No.]),_len)=LEFT(MAX('Slice_table'[Project No.]),_len),1,0),
    0
)

 Drop the measure to visual level filter as:

Here is the output:

You can try the attached demo.

Best Regards,
Link

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

[amitchandak]

@jay_patel , do you have a project column with a value format you are sharing.

Based on what I can see, You need one

Project Code = left[project no.], 7)