Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Caculate percentaje from visual tables

Hi, I want to calculate a percentaje from one visual table wit another visual table.   I need in "cartera Vencida" agregate additional column with the percentaje bettwen del Net Oist. from "Cartera...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous ok, change the measure as below

     

    % Total = 
DIVIDE( 
    SUM ( Aging[Net Outstanding] ), 
    CALCULATE ( 
        SUM ( Aging[Net Outstanding] ), 
        ALL ( Aging[G. Vencidos] )
    )
)

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous here is the measure

 

% Total = 
DIVIDE( 
    SUM ( Aging[Net Outstanding] ), 
    CALCULATE ( 
        SUM ( Aging[Net Outstanding] ), 
        ALL ( Aging )
    )
)

 

and here is the output

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks, the problem is when i Select (for example Juan) the calculate has a mistake, because  the % for A:1-30 say 15.94% and the real % will be 21%.

 

I add the picture

 

Thanks by your help Parry2k

 

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    Anonymous ok, change the measure as below

     

    % Total = 
DIVIDE( 
    SUM ( Aging[Net Outstanding] ), 
    CALCULATE ( 
        SUM ( Aging[Net Outstanding] ), 
        ALL ( Aging[G. Vencidos] )
    )
)

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks a lot, now is working, your a great.