Caculate percentaje from visual tables

[Anonymous]

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

[parry2k]

@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]

Thanks Parry2k, how to add the pbix?

[parry2k]

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

[parry2k]

@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]

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 · Accepted solution]

@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]

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

[Anonymous]

 attahc the link in one drive

https://1drv.ms/u/s!AjPn6l8NWmiuj1UOdxbTIhwKQjL6?e=zSmvIe