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 share sample pbix file, it is not sure how these table are related, logically it should be

 

% = 
DIVIDE ( [Net OUst.], CALCULATE ( [Net Outstanding], ALLSELECTED( Table[Provincia] ) ) )

 

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 Parry2k, how to add the pbix?

 

 

 

 

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

    Anonymous use one drive or google drive or send directly to me by email which is in my signature below.

    • 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