Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Column calculated based on multiple row values

Good I'm pretty inexperienced in Power BI, I apologize in advance. If the example is too extensive, it is also worth having a guide of possible functions to use, et.c. I have two tables, one ...
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Hello

Thanks for the quick response. I can think of something like this:

ReadingCreationModificationEraseUser Type
X Reader
XX Creator
XXX Editor
XXXXManager

Thank you

Jose

mangaus1111's avatar
mangaus1111
Solution Sage
3 years ago

Hi Syndicate_Admin ,

it seems to me that your new table does not help to improve the model. What your table do, it is setting the rules, but the rules are already inside my measure.

To improve the model, I suggest you to use this other measure that takes into account all the possible combinations of permissions, for example if you need 2 different kind of Editor

Measure 2 = 
SWITCH(
       MAX('Final Table'[Path]),
       "Reading","Reader",
       "Reading|Creation","Creator",
       "Reading|Modify","Editor Level I",
       "Reading|Creation|Modify","Editor Level II",
       "Reading|Creation|Modify|Erase","Manager",
       "Not classified"  
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.