Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Child | Parent |
AAA | 1 |
BBB | 1 |
CCC | 1 |
AAA | 2 |
DDD | 2 |
FFF | 2 |
BBB | 3 |
CCC | 3 |
DDD | 3 |
FFF | 3 |
AAA | 4 |
FFF | 4 |
GGG | 4 |
SSS | 4 |
My requirement
If i select AAA then display like
Child | Parent |
AAA | 1 |
BBB | 1 |
CCC | 1 |
AAA | 2 |
DDD | 2 |
FFF | 2 |
AAA | 4 |
FFF | 4 |
GGG | 4 |
SSS | 4 |
Please help me on this
thank you in advance
Solved! Go to Solution.
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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!!
When I select CCC
Child | Parent |
AAA | 1 |
BBB | 1 |
CCC | 1 |
BBB | 3 |
CCC | 3 |
DDD | 3 |
FFF | 3 |
@Anonymous I am not being rude, but you haven't even written a single full sentence, how would someone understand what you are trying to achieve? 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |