Forum Discussion
Help with a dynamic bridge please
Hello, I am very new to PBI - so your patience and help with my supposedly basic request is highly appreciated. I have the following table. Ref is unique text. Tasks are unique too. I need to geta...
Anonymous OK, create 2 disconnected tables (no relationships). Let's say you didn't rename the Attribute and Value columns after unpivoting, create your slicer tables like this:
Slicer Table 1 = DISTINCT('Table'[Attribute])Slicer Table 2 = DISTINCT('Table'[Attribute])Now, create a measure like this:
Measure = VAR __Month1 = SELECTEDVALUE('Slicer Table 1',[Attribute]) VAR __Month2 = SELECTEDVALUE('Slicer Table 2',[Attribute]) VAR __Table1 = DISTINCT(SELECTCOLUMNS(FILTER('Table',[Attribute] = __Month1 && [Value] = "Open"),"__Ref",[Ref])) VAR __Table2 = DISTINCT(SELECTCOLUMNS(FILTER('Table',[Attribute] = __Month2 && [Value] = "Closed"),"__Ref",[Ref])) RETURN COUNTROWS(INTERSECT(__Table1, __Table2))
Greg_Deckler
Community Champion
Community ChampionAnonymous OK, create 2 disconnected tables (no relationships). Let's say you didn't rename the Attribute and Value columns after unpivoting, create your slicer tables like this:
Slicer Table 1 = DISTINCT('Table'[Attribute])Slicer Table 2 = DISTINCT('Table'[Attribute])Now, create a measure like this:
Measure =
VAR __Month1 = SELECTEDVALUE('Slicer Table 1',[Attribute])
VAR __Month2 = SELECTEDVALUE('Slicer Table 2',[Attribute])
VAR __Table1 = DISTINCT(SELECTCOLUMNS(FILTER('Table',[Attribute] = __Month1 && [Value] = "Open"),"__Ref",[Ref]))
VAR __Table2 = DISTINCT(SELECTCOLUMNS(FILTER('Table',[Attribute] = __Month2 && [Value] = "Closed"),"__Ref",[Ref]))
RETURN
COUNTROWS(INTERSECT(__Table1, __Table2))
ok, this looks extremely promising. Let me try and get back on this. Greg_Deckler , so nice and helpful of you.