Forum Discussion

sprao's avatar
sprao
Helper I
6 years ago
Solved

Value sum from Lower level-High

Hi Experts,   Could you please help me below scnario..i am struggling to get solution..This calcultion with out any Dim table or Copy Table need solution.   Graph 1 need sum values for level 1(Ac...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, sprao 

    In the ‘Fields’ pane, you can create two measure. Here they are.

     

    SumActual = CALCULATE(SUM('Table B'[Actual Sales]),FILTER(ALL('Table B'),[Actvitity] in FILTERS('Table A'[Actvitity]) || [Actvitity] in SELECTCOLUMNS(FILTER(ALL('Table A'),[ReferA Activity] in FILTERS('Table A'[Actvitity])),"Refer",[Actvitity])))

     

    SumTarget = CALCULATE(SUM('Table A'[Target Sales]),FILTER(ALL('Table A'),[Actvitity] in FILTERS('Table A'[Actvitity]) || [ReferA Activity] in FILTERS('Table A'[Actvitity])))

     

    Then you can create clustered column charts with measures dragged to the visual level filter pane.

    Result:

      

     

    If I misunderstand the your thoughts, please inform me of your expected output. I am glad to solve the problem for you.

     

    Best Regards,

    Allan

     

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

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, sprao 

In the ‘Fields’ pane, you can create two measure. Here they are.

 

SumActual = CALCULATE(SUM('Table B'[Actual Sales]),FILTER(ALL('Table B'),[Actvitity] in FILTERS('Table A'[Actvitity]) || [Actvitity] in SELECTCOLUMNS(FILTER(ALL('Table A'),[ReferA Activity] in FILTERS('Table A'[Actvitity])),"Refer",[Actvitity])))

 

SumTarget = CALCULATE(SUM('Table A'[Target Sales]),FILTER(ALL('Table A'),[Actvitity] in FILTERS('Table A'[Actvitity]) || [ReferA Activity] in FILTERS('Table A'[Actvitity])))

 

Then you can create clustered column charts with measures dragged to the visual level filter pane.

Result:

  

 

If I misunderstand the your thoughts, please inform me of your expected output. I am glad to solve the problem for you.

 

Best Regards,

Allan

 

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