Power BI Exchange

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

Get a Table with All applied Internal and External filters except on one column

  • 1.  Get a Table with All applied Internal and External filters except on one column

    Posted 13 days ago


    Hi All!

    Is there any way I can return a table with all the explicit and implicit filters applied, within calculate function, but remove filter, if any, on one column?

    I tried with ALLSELECTED and it gives correct result by month until I do not pull any other dimension/column. I understand that ALLSELECTED is keeping All External Filters context but then taking off any applied internal filter. Here is the formula. Any suggestion is much appreciated.

     

    PriorMonthSales =

    CALCULATE([+FY20Sales],

    FILTER(

    ALLSELECTED(FY20MonthlyData),

    FY20MonthlyData[Period]=PriorMonth)

    ),

    blank())

    ·      

     

     

    Best Regards,

    Gaurav

     

     

     

     

     

     

     

     

     

     


    ___________________________________
    The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. EY is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.