Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Percentage calcualtion for two different tables

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. 

 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    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's avatar
    Anonymous
    1 year ago

    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's avatar
    Anonymous
    1 year ago

    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's avatar
    Anonymous
    1 year ago

    Hello Gao,

     

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

     

11 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
      Anonymous
      Not applicable
      1 year ago

      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's avatar
        Anonymous
        Not applicable
        1 year ago

        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's avatar
      Anonymous
      Not applicable
      1 year ago

      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.

       

  • dharmendars007's avatar
    dharmendars007
    Icon for Memorable Member rankMemorable Member
    1 year ago

    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's avatar
    dharmendars007
    Icon for Memorable Member rankMemorable Member
    1 year ago

    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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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?