✔ Programação GLOBAL®: Power BI | Pull Goals into a Matrix, then do calculations

Power BI | Pull Goals into a Matrix, then do calculations

I have created the "relationship" between the two datasets by linking the "Sales" in the Production dataset with the "Target Sales" in the Goals dataset, but that doesn't seem to help... PBI wants to do some sort of calculation on the goals, and "do no calculation" doesn't seem to be an option.

Resolution of the first part of the problem, which is to display the Target value in the Matrix.

How?

Still in the Power BI 'Table Display' area, after using a DAX function to retrieve the Goal value from another table, adding it as a new column in the current table, convert it to text:

Target = CONVERT( LOOKUPVALUE( Sales[Target], TargetSales[Cod], Territory_Sales[Cod]), STRING)

This way, the retrieved Target will not be aggregated or undergo any calculation action when shown in the Matrix in the 'Report Display' area of Power BI, as it will appear as the First Value.

Resolution of the second part of the problem: Perform calculations based on the retrieved Target. If you need to use the value for specific calculations, simply use it without the corresponding conversion to text in the 'Table Display' area of Power BI.

Power BI: