Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Child and parent filter

My requirement is I have Main table that is below and Imported into Power BI made table visual and taken Child field as a slicer and when choose any Child filed please see My requirement Main table ...
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    You can achieve this by creating a separate disconnected table for the Child column.

    You can download the file: HERE

     

    Measure = 

var __childselected = SELECTEDVALUE('Child Table'[Child])
var __table = 
    CALCULATETABLE( 
        'Main Table',
        'Main Table'[Child] = __childselected 
    )
return
ISEMPTY(__table) * 1

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn

     

     

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

Anonymous 

You can achieve this by creating a separate disconnected table for the Child column.

You can download the file: HERE

 

Measure = 

var __childselected = SELECTEDVALUE('Child Table'[Child])
var __table = 
    CALCULATETABLE( 
        'Main Table',
        'Main Table'[Child] = __childselected 
    )
return
ISEMPTY(__table) * 1

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

 

 

Krista's avatar
Krista
Frequent Visitor
3 years ago

Fowmy -- I've run into this same issue and I think your solution will work, but I can't access the file you linked to. I've created the separate table and measure, but I'm not sure where to go from there. Which table is the measure supposed to be created in? From which table do I use the Child field for the slicer?

 

Thanks!!