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 created calculated column using switch formula. I did some charts and created measures. One of them is a stacked column chart where revenue is distributed over months and grouped by payments status (based on calculated column).

 

As I show absolute numbers it is advised to show as well % of subtotal for each status in the tooltip. I created a measure where I divide absolute number by subtotal.

 

DIVIDE([SalesValue],CALCULATE([SalesValue],ALLSELECTED(Oders_table[payment_type_switch])))

 

This is where my problem starts. If I use in chart and formula calculated column always 100% is returned (allselected is not working). If I use not formatted column I do have proper results:

 

DIVIDE([SalesValue],CALCULATE([SalesValue],ALLSELECTED(Oders_table[payment_type)))

 

How to calculate % of subtotal having in chart formatted statuses?

Need Help

7 Replies

  • 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.

       

       

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Borrek ,

     

    Or try this.

    DIVIDE(
    [SalesValue],
    CALCULATE(
        [SalesValue],
        ALLEXCEPT( Oders_table, Oders_table[payment_type_switch] )
    )
)

    If the problem is still not resolved, please provide sample data and screenshotes of the visual.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.