Reporting data without losing calculation

[papuzu]

hELLO There

I've created a Column-Z which calculate a division between two source of data : as numerator a put profit earned (column-A) and denominator the price sold (Column-B)

I have then a row for each of this new column-z calculation applied. 

When a try to visualize this new column created with some bigger sub-set (for example Country Canada has lot of products with different profit (column A) and price earned (column B)) then the Column-Z reported is simply the average of the whole list of products reported for Country Canada, while this column should recalculate the whole Column-A (profit earned) with Column-B price sold to deploy the exact % of margin to represent the Country Canada  

Thanks for helping 

[Nathaniel_C]

Hi @papuzu , this is not clear.  Either share the .pbix, or mockup something in Excel with current data and expected outcome.  Then copy the cells and paste into the code window (<>) which comes from the input menu.

If you would share your pbix, or dummy up some values in Excel both for current and expected data. Please copy and paste them into your post, rather than doing a picture, we may be able to help you. 

Please read this post to get your question answered more quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Nathaniel

[papuzu · Accepted solution]

Hello @Nathaniel_C 

I thought I had reply to this query. 

I've solved this by myself because it was the -measure- the parameter to adopt and not a simple calculation