ACTUAL vs TARGET

thebruuu — Wed, 30 Mar 2022 20:26:42 GMT

Hello

I need to compare actual sales vs target and when target is achieved I need to be able to write "[Target Name] Achieved"

Here's my model:

DIMS contains my items per year and per group (REQUESTED_ITEM_KEY is unique for a year and a group)

In Sales, I keep track of each sale action (quantity not needed righ now, assume it to be 1)

And a sale action has a status OK/NOK

A target is identified by a Target Label (that is the concatenantion of the ID, GROUP, and YEAR)

A target definition concerns several Items (several REQUESTED_ITEM_KEY) and for each item I can specify the requested quantity for the target to be achieved; only if all the lines concerning a Target are achieved, the target is achieved too

When checking for target compliance, I only need to take from Sales, those lines for which the status is "OK"

The DIMS table has been built by extracting all the REQUESTED_ITEMS available in the other two table, by GROUP and YEAR

I am able to :

Count for a TARGET Label, and a REQUESTED ITEM, the corresponding lines in SALES for which the Sales Rep have a Status="OK"

But When I compare this value with the REQUESTED QUANTITY I get a CIRCULAR DEPENDENCY

At the end I would like to build a matrix as the one below

Thank You!

Re: ACTUAL vs TARGET

lbendlin — Fri, 01 Apr 2022 01:16:39 GMT

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

topic ACTUAL vs TARGET in DAX Commands and Tips

ACTUAL vs TARGET

Re: ACTUAL vs TARGET