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.

      • jackl21an's avatar
        jackl21an
        Regular Visitor
        1 year ago

        I also found this worked; when I included 2 ALLSELECTED statements, one for the dimension and the other for the column I was using to sort the dimension (used to sort the legend in a bar chart). Slight difference to yours is that in my case they were both were held in a separate reference table with a relationship on a calculated column in the main dataset.