Column and Measure (DIVIDE)

[NickProp28]

Dear Community, 

My measure and column have the same formula, but the column didn't display the 84.21%.

Btw,all these selections did not get the result I was looking for

Formula

Measure:

% = DIVIDE(SUM('SIT'[C_Count]), SUM('SIT'[Total]))

Column: 

divs = DIVIDE(SIT[C_Count] ,SIT[Total])

Any assistance would be greatly appreciated

Thank you!

[amitchandak]

@NickProp28 , For a don't Summarize column you will not get total. (Based on what I got)

[NickProp28]

Dear @amitchandak ,

Yup, but I will still not get the 84.21% result if I select median.

Would it be possible to get the 84.21% in a column format?

[v-xiaosun-msft · Accepted solution]

Hi @NickProp28 ,

According to your description, here is my solution.

You cannot use a calculated column to display 84.21% in the bottom total value of a table or matrix.

When you use calculated column, of course, if you use "Don't summarise", it will not do any summary calculations. But, even if you choose "Sum", it just sums the values in the current column instead of using the same calculated column formula.

When a Measure is used on rows in a table, the column total for those rows is not calculated based on a sum of the results in the rows, but instead it calculates using the same Measure formula and applies it to the total of the data selected.

Please refer to the following documents.

Create a matrix visual in Power BI - Power BI | Microsoft Learn

How to Make Measures Total Correctly in Power BI Tables - ArcherPoint

Power BI Column vs Measure. Which one should I use and when? | by Peter Hui | Towards Data Science

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.