What is the difference between ALL() & REMOVEFITLERS() DAX Functions? | Power BI | BI Consulting Pro

Поділитися
Вставка
  • Опубліковано 11 жов 2024

КОМЕНТАРІ • 23

  • @BIConsultingPro
    @BIConsultingPro  3 роки тому +2

    Please download the .pbix file from the following link and share your feedback!
    1drv.ms/u/s!ApIf9f9Q3qOxkyJLhRKeUsBtg_bs?e=ZvgOzk

    • @ashishmohan4707
      @ashishmohan4707 3 роки тому

      Hi Ajay Sir
      pbix file is not correct
      this is same for previous video RLS/OLS
      this is not ALL & REMOVEFITLERS file.
      please check

    • @BIConsultingPro
      @BIConsultingPro  3 роки тому +1

      @@ashishmohan4707 My apologies! I have updated the link! thank you for your comment! Please find the file here: 1drv.ms/u/s!ApIf9f9Q3qOxkyJLhRKeUsBtg_bs?e=ZvgOzk

    • @ashishmohan4707
      @ashishmohan4707 3 роки тому +2

      @@BIConsultingPro thank you sir

  • @AliBuKarrar
    @AliBuKarrar 2 роки тому +1

    Its exactly what I am looking for. Thank you.

  • @PedroCabraldaCamara
    @PedroCabraldaCamara 2 роки тому +1

    Great! Very well explained 🙂

  • @amitgoyal7189
    @amitgoyal7189 3 роки тому

    Hello Ajay, as you showed in the last example, REMOVEFILTER can not be used in SUMX because of return type. What if we use CALCULATE and inside CALCULATE we use SUMX and REMOVEFILTER.

    • @BIConsultingPro
      @BIConsultingPro  3 роки тому

      I'll suggest please try first yourself and if you cannot find a solution then share with me your work and then I'll help you!

  • @raghunadhamara6243
    @raghunadhamara6243 3 роки тому

    Hi experts , I just publish a report for 10 users and except 1 all are able to view.
    There is no role change or permission changes .
    How can i trouble shoot it . Can anyone please help me with it

    • @BIConsultingPro
      @BIConsultingPro  3 роки тому

      Did you check the user email address? Did you check whether that user has license or not? If there is RLS, did you add correctly that user email address on Power BI Service, under security on Dataset? Please check these steps.

    • @raghunadhamara6243
      @raghunadhamara6243 3 роки тому

      @@BIConsultingPro thanks for the responce . I had done these steps and found no error from my end so just raised a support ticket .

  • @anjim8507
    @anjim8507 3 роки тому

    Where can I get the source files for practice the dax

    • @BIConsultingPro
      @BIConsultingPro  3 роки тому

      Unfortunately, you cannot. However, you can download free databases like adventureworks DW 2019 etc from this link and start working on it: docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms

  • @ashishmohan4707
    @ashishmohan4707 3 роки тому +1

    Hello Ajay Sir,
    Video is very useful but i am not able to find pbix file
    can you plzz share pbix file here .
    Thanx
    AM

    • @BIConsultingPro
      @BIConsultingPro  3 роки тому

      Did I check the link I provided you in the following comment? Please try again:
      1drv.ms/u/s!ApIf9f9Q3qOxkyJLhRKeUsBtg_bs?e=ZvgOzk

    • @ashishmohan4707
      @ashishmohan4707 3 роки тому

      @@BIConsultingPro thank you sir

    • @ashishmohan4707
      @ashishmohan4707 3 роки тому

      Hello sir i have gone through with your pbix file
      That is amazing
      Were you prepared this "Overview" page on power point
      Plzz let me know.
      I also want same .

    • @BIConsultingPro
      @BIConsultingPro  3 роки тому

      @@ashishmohan4707 It's in Canva

    • @ashishmohan4707
      @ashishmohan4707 3 роки тому

      @@BIConsultingPro power BI canva or canva software