Forum Discussion
Reporting data without losing calculation
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
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
2 Replies
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
NathanielHello 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
