Forum Discussion
One report for multiple users
- 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
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
Thanks MFelix.
The link is really helpful. I should have googled it before posting question here though :). Thanks for your time.
Regards
Harshad
- MFelix8 years agoSuper User
Hi Anonymous,
No problem the forum exists for this :D
Regards,
MFelix
- Anonymous8 years agoNot applicable
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
- Anonymous8 years agoNot applicable
Sorry got it!
I used the following
[Category] = "BMV" && [Category] = "BLD"
and its validated successfully.
Thanks!