Hi I have an issue where my filter doesn't seem to be able to identify the correct value to filter on:
Filter(colDistinctMembers,displayName.displayName in "Username")
Obviously username is a proper username.
The colDistinctMembers collection has 2 levels.displayName which is a tableand userPrincipleName which is a column.
The table underneath displayName also has a displayName column which is the column I want to filter on.
I'm not sure why my filter query above is giving me a table value error.
Go to Solution.
Hi @Mr0bb0 ,
Please modify formula as below:
Filter(colDistinctMembers, "Username" in displayName.displayName )
View solution in original post
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand