Forum Discussion
Solved
Add a calculated column to a Matrix visualization
I am using a Power Bi matrix visualization to display a series of data. I have two datasources. The first is my data I want to display and the second is my target values. There is a Mant to One rel...
Got it to work. (Used a new name) What I did was use a measure. I only wanted one value for the target. The relationship is Many to One. Since there is only one value in the target type for each category I used MIN (again because there is only one value I could have just as easily used MAX) instead of sum for the target.
To Be Released = CALCULATE( MIN(SuperMarketData[Target]),ALLSELECTED(TargetData)) - CALCULATE( SUM(SuperMarketData[Before SuperMarket]) + SUM(SuperMarketData[In SuperMarket]),ALLSELECTED(TargetData))
OK, a lot going on here, need sample data in text format and then what you expect in your new column and why. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490