Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Filter the same table two times with item slicer

Hi community,   I have two tables People table: People name People id Amy 001 Peter 002 Paul 003   Poject table: People ID project ID 001 XX 001 YY 001 ZZ ...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , In sunc case prefer to use an independent people table

 

Number of related project =
var _tab = summzarize(filter(project, project[People ID] in SELECTEDVALUE(People[People ID])), [Project ID]
return
calculate(
distinctcount(project[project ID]),filter( project, project[Project ID] in _tab))

 

or when joined

 

Number of related project =
var _tab = summzarize(filter(project, project[People ID] in SELECTEDVALUE(People[People ID])), [Project ID]
return
calculate(
distinctcount(project[project ID]),filter( project, project[Project ID] in _tab), removefilter(People) )

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi amitchandak,

 

Thanks for replying. Could you explain more on two measures you provide?

I tried to create those measure, but there are syntax error in the var _tab.