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?