Forum Discussion
Solved
Display a clusterd column chart based on filtered value
the first picture is my dataset, in this dataset, I have a parent, child, and value. I want to put a slicer that contains child values, and when I select a child I show all his brothers with...
Hi Omar_Sek ,
Try this:
Measure = VAR SelectedChild = SELECTEDVALUE ( 'Child Table'[child] ) VAR SelectedParent = CALCULATE ( MAX ( 'Table'[parent] ), 'Table'[child] = SelectedChild ) RETURN IF ( MAX ( 'Table'[parent] ) = SelectedParent, 1 )Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Omar_Sek ,
Try this:
Measure =
VAR SelectedChild =
SELECTEDVALUE ( 'Child Table'[child] )
VAR SelectedParent =
CALCULATE ( MAX ( 'Table'[parent] ), 'Table'[child] = SelectedChild )
RETURN
IF ( MAX ( 'Table'[parent] ) = SelectedParent, 1 )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.