Percentage calcualtion for two different tables

[Anonymous]

Hello, I'm new in Power BI and would like to do percentage of two different tables imported from a SQL server. If I have two columns the next each other, I assume it would be easy like in Excel but how can I perform a percentagate calculation from two different tables imported from an SQL server? I attached two pictures of two tables. 

[Anonymous · Accepted solution]

Hi @Anonymous ,

Based on the description, try the following measures:

Closed / Total = 
VAR __closed = CALCULATE(COUNTROWS('Table'),'Table'[Case]="Closed")
VAR __total = CALCULATE(COUNTROWS('Table'),ALL('Table'[Case]))
VAR __result = DIVIDE(__closed,__total)
RETURN
__result

Leading / Leading Total = 
VAR __leading = CALCULATE([Your leading measure], 'Table'[Case]="Closed")
VAR __leading_total = CALCULATE( [Your leading measure], ALL('Table'[Case]))
VAR __result = DIVIDE( __leading, __leading_total )
RETURN
__result

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum 

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can turn off text warp for the Column headers and Values, and then manually drag to adjust column widths to achieve the hiding effect.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum 

[Anonymous · Accepted solution]

Hi @Anonymous ，

... turn off text warp for the Column headers and Values...

Please check if Text Wrap under Values is turned off.

Best Regards,
Gao
Community Support Team

[Anonymous · Accepted solution]

Hi @Anonymous ,

Based on the description, try the following measures:

Closed / Total = 
VAR __closed = CALCULATE(COUNTROWS('Table'),'Table'[Case]="Closed")
VAR __total = CALCULATE(COUNTROWS('Table'),ALL('Table'[Case]))
VAR __result = DIVIDE(__closed,__total)
RETURN
__result

Leading / Leading Total = 
VAR __leading = CALCULATE([Your leading measure], 'Table'[Case]="Closed")
VAR __leading_total = CALCULATE( [Your leading measure], ALL('Table'[Case]))
VAR __result = DIVIDE( __leading, __leading_total )
RETURN
__result

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum 

[Anonymous]

Hello Gao,

The other percentage works excellent as well Thank you ,again the same problem it repeats all the way to the end, how can I setup filtering for visualisation? I want to keep it only in red circle.

[Anonymous]

Hello Gao,

Thank you for help and response. I tested the first code and it works, Thank you, but how to keep it percentage only in the red cicle? It repeats all the way to the end of table. How can manage it? 

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can turn off text warp for the Column headers and Values, and then manually drag to adjust column widths to achieve the hiding effect.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum 

[Anonymous]

I tried that above and it makes wider rows.... any solution for that?

[Anonymous · Accepted solution]

Hi @Anonymous ，

... turn off text warp for the Column headers and Values...

Please check if Text Wrap under Values is turned off.

Best Regards,
Gao
Community Support Team

[Anonymous · Accepted solution]

Hello Gao,

Thank you, excellent work I turned off only for Column headers ..and not for Values.. now it works Thanks again.

[Omid_Motamedise]

Please provide the data of your example as a table here

[Anonymous]

Would be easier to split "Case Column" into new columns ,create new columns for None, closed etc. for visualition and percenttige calculation? if so how can we do that?

[dharmendars007]

Hello @Anonymous , 

Can you please confirm the columns names you are referring to which is used to calculate the percentages, with the expected result..

And also to your point if we can calculate the percentages based on two tables ? Yes, we can do it.

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[dharmendars007]

Hello @Anonymous , 

Can you please confirm the columns names you are referring to which is used to calculate the percentages, with the expected result..

And also to your point if we can calculate the percentages based on two tables ? Yes, we can do it.

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN