Forum Discussion

Borrek's avatar
Borrek
Frequent Visitor
6 years ago
Solved

ALLSELECTED on Calculated Column not working

Hi,   I tried to find the solution to my problem for over a while. Unfortunately without success.    I do have payments statuses in my database that are not properly formatted for end user. So I ...
Need Help
mhossain's avatar
mhossain
Solution Sage
6 years ago

Hi Borrek 

 

Try this DIVIDE([SalesValue],CALCULATE([SalesValue],ALL(Oders_table))

  • Borrek's avatar
    Borrek
    Frequent Visitor
    6 years ago

    Hi, thanks for answering but this eliminates all filters - I need to eliminate only payment status filter.

     

    What is wired that the only difference between working and not working formula is the column. If I use column imported from database (and change legend in chart respectively) it works. If I change both to calculated column (SWITCH function on imported column) it does not.

     

    I read about shadow filter so I also tried to insert both columns in ALLSELECTED but it does not work as well.

     

     

    • mhossain's avatar
      mhossain
      Solution Sage
      6 years ago

      Borrek 

       

      Can you share the sample pbix with dummy data, can try

      • Borrek's avatar
        Borrek
        Frequent Visitor
        6 years ago

        The problem was that ALLSELECTED should be not only imposed on payment_type calculated column but also calculated column that was used to sort payment_type column.

         

        Not sure why but sorting by other column affected contex filters of column I used. I was able to find it by removing filters.

         

        From my point of view such situation is counterintuitive but this is how it works.