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 ...
mangaus1111's avatar
mangaus1111
Solution Sage
3 years ago

Hi Syndicate_Admin ,

sorry, I am not able to answer to your second question. Maybe if you send me a sample of this intermediate table, I could better imagine what is an alternative solution.

 

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

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.