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 Vencida" to the total en Customer Name.

 

But if a change the name, for example from Select All to Pablo the total Change (1.508k) and the % in the Cartera vencida  is other

How to do that? 

 

Thanks a lot

 

 

 

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!

8 Replies

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