Percentage calcualtion for two different tables

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 

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 

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

Hello Gao,

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