Operation with the total of a column

[Tiff]

Hi all, 

I'd like to create something that I never did on Power BI. 

In my report, I have a table, with various columns and total. 
How can I make the percentage of the total with the total in another table ? 

To be more specific, I have for exemple a total of 200 units in my first table. In my second table, I have a total of 2000 units. 
I can easily guess that 200 is 10 % of 2000. But how to write this calcul ? Is there a way ? 

Thank you for your help, 

Tiff 

[v-juanli-msft]

Hi @Tiff

As pattemmanohar's suggestion, you could create a measure like

1. if the "total" is a column with data of Type Number

MAX(Table1[Total 1])/MAX(Table2[Total 2])

2.if the "total" is to calculate the total of a column

CALCULATE(SUM(Table1[column1]),ALL(Table1))/CALCULATE(SUM(Table2[column2]),ALL(Table2))

What is the relationship between the two tables?

If there is some trouble implementing this, please share some data example with me for better annalysis.

Best Regards

Maggie

[Tiff]

Hi Maggie, 

Thank you for your answer. The problème is that the total (sum) of my column change with the filter (Date etc...). So I want to divise the total of the big board, by the total of the little board... But because the total changes, I don't success ! It's not the total of the column in the Table. I don't know if I'm clear enough... 

With "create new mesure", It make the operation in the table in data. But in my report, I have filters to apply... 


I hope you can help me... Thanks a lot 

Tiff  

[v-juanli-msft · Accepted solution]

Hi @Tiff

Create measures (Sheet11->big board,Sheet12->little board)

Measure = CALCULATE(SUM(Sheet11[def]),ALLSELECTED(Sheet11))

Measure 2 = CALCULATE(SUM(Sheet12[def]),ALLSELECTED(Sheet12))

Measure 3 = [Measure]/[Measure 2]

Best Regards

Maggie

[Tiff]

Maggie, 

It works, yes. But I realized that 249*100/9337 is not 0.674735.... 
Is there something to do to adapt the operation ? It's strange, I don't understand why the result is not 2.66... 

Thank you for your help... 
Tiffaine 

[PattemManohar]

@Tiff Please try creating as a "Measure"