Power BI For Data Science

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
  • 1.  Great question

    Gold Contributor
    Posted Nov 01, 2019 11:12 PM
    Good evening everyone,


    I have created a report on Power BI applying RLS for district supervisors. Each supervisor login in and see only his sales over his district. I would like to add a comparison of his sales against the total sales of the whole city.

    I have applied many functions to ignore the RLS but it doesn't work.

    Total = CALCULATE(SUM('Table'[Sales]), ALL('Employees'[SupervisorName]))

    I used ALL, ALLSELESTED but none of them works.

    Please help.

    ------------------------------
    S B
    Data Manager
    ------------------------------


  • 2.  RE: Great question

    Top Contributor
    Posted Nov 02, 2019 03:19 AM
    Hi @S B
    See my reply on the Algeria PUG​

    ------------------------------
    Regards
    Mehdi HAMMADI
    CoGitar / 23389830
    mehdi.hammadi@cogitar.com
    ------------------------------



  • 3.  RE: Great question

    Top Contributor
    Posted Nov 02, 2019 03:20 AM
    Hi @S B
    See my reply on Algeria PUG​

    ------------------------------
    Regards
    Mehdi HAMMADI
    CoGitar / 23389830
    mehdi.hammadi@cogitar.com
    ------------------------------



  • 4.  RE: Great question

    Top Contributor
    Posted Nov 04, 2019 06:08 AM
    Hi @Mehdi HAMMADI,

    Please can you share the link for your reply.

    Thank you,​

    ------------------------------
    Vishesh Jain
    Owner
    VR Construction
    ------------------------------



  • 5.  RE: Great question

    Top Contributor
    Posted Nov 06, 2019 06:51 AM
    Hi @Vishesh Jain,
    Here is the discussion https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=e9794f85-0f50-4c35-a770-b9e424d8abda&CommunityKey=b53b454c-0560-4600-a098-9b1887af0d85&tab=digestviewer#bme9794f85-0f50-4c35-a770-b9e424d8abda

    ------------------------------
    Regards
    Mehdi HAMMADI
    CoGitar / 23389830
    mehdi.hammadi@cogitar.com
    ------------------------------