Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

One report for multiple users

Hello,   I have one requirment when I need to crate one report and that report will be shared across 10 usres but the report should show only the user specific data i.e. if user1 logged in to power...
Show and Tell
  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    I believe that the best way is to use the Row Level Security check this link with explanations or just google: Power Bi Row Level Security.

     

    Regards,

    MFelix

  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    Below see the notation for AND and OR filter:

     

    AND notation

Calculate (Sum([Value], [Category] = "BLD" && [Category] = "BMV")

OR notation

Calculate (Sum([Value], [Category] = "BLD" || [Category] = "BMV")

    I have made it inside a calculate just for better understanding.

     

    Regards,

    MFelix

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks MFelix

 

Need more help. Do you know how I could use the 'AND' condition while makinh the role? I used following but its not accpeting.

 

([Category] = "BLD" and [Category] = "BMV")

 

I am try to check on google but can't find any help yet. Please advise.

 

Thanks!

Harshad

MFelix's avatar
MFelix
Super User
8 years ago

Hi Anonymous,

 

Below see the notation for AND and OR filter:

 

AND notation

Calculate (Sum([Value], [Category] = "BLD" && [Category] = "BMV")

OR notation

Calculate (Sum([Value], [Category] = "BLD" || [Category] = "BMV")

I have made it inside a calculate just for better understanding.

 

Regards,

MFelix

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    MFelix

    Really appreciate your time and efforts in this matter. Thank you again!

     

    Regards

    Harshad