question

AbhishekSahu-3552 avatar image
0 Votes"
AbhishekSahu-3552 asked LukasYu-msft commented

Add more than two Row Filters for Different Columns on Same Table

Hi Experts,

I want to add One more Row Filter for DimClub Table in SSAS role Properties, One Filter is Already in place to Filter the Authentication using LOOKUPVALUE. I want to add one more Filter in this Saying "Please filter these Authenticated people to not see Club name 'XDSS' "

"=DimClub[ActiveDirectoryGroup]=LOOKUPVALUE(Userprofile[DefaultClub],Userprofile[UserName],USERNAME(),Userprofile[DefaultClub],DimClub[ActiveDirectoryGroup])" this Filter is already in place for table DimClub.. I want to add

"='DimClub'[ClubStatus] <> "XDSS" " Can it be Possible to in single statement!!?

I tried with this..

"=DimClub[ActiveDirectoryGroup]=LOOKUPVALUE(Userprofile[DefaultClub],Userprofile[UserName],USERNAME(),Userprofile[DefaultClub],DimClub[ActiveDirectoryGroup]) && DimClub[ClubStatus] <> "XDSS" ".. bad luck in this.. it is not working..

Please help me here . Thanks in Advance.

sql-server-transact-sqlsql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented

Hi,


Try use the expression like this :
=AND(DimClub[ActiveDirectoryGroup]=LOOKUPVALUE(Userprofile[DefaultClub],Userprofile[UserName],USERNAME(),Userprofile[DefaultClub],DimClub[ActiveDirectoryGroup]), DimClub[ClubStatus] <> "XDSS" )


When we want to use multiple filters in a table we follow this format as :


   =AND(filter1,AND(filter2,AND(filter3,filter4)))     


Regards,

Lukas







· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,
We did not hear from you back? Did this help to solve your problem?

0 Votes 0 ·