Target vs Actual

[bhaddour]

Hello everyone, 

Need some help on this one !

I have stores in a sub region , and sub regions in a region . 

I have a KPI (OPTI) calculated at a store level. This KPI is calculated from 2 tables. And this calculation is done by creating a measure on Power BI. This is the actual KPI. 

In an other hand, I have the constant target for the same KPI per store. 

How can I integrate those two informations in one table to be able to see the actual vs target , per store, per sub region and per region ? When I want the target to be shown for sub region it does the sum of ther targets.

The stores , sub region and region are in one table linked to the others. I created one table for targets for each level (store,sub region and region)

Thanks a lot 

[v-eqin-msft]

Hi @bhaddour ,

 Any updates? As @lbendlin  said, we need more details about your table and your problem to clarify your scenario.If you do not know how to upload sample, please kindly refer to the blogs below. And remember to remove sensitive data firstly before uploading.

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Some similar threads about Actual vs Target:

https://www.goodly.co.in/actual-vs-budget-calculations-dax-powerbi/

https://databear.com/adding-targets-in-power-bi-report/

https://powerbi.microsoft.com/fr-fr/blog/actual-vs-budget-which-chart-is-effective/

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bhaddour]

How would I do that ?

[lbendlin]

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.

[lbendlin]

"When I want the target to be shown for sub region it does the sum of ther targets"

Power BI has no idea how you want to compute the target for a sub region. You will need to decide how it should be computed, and then create a measure or calculated column accordingly.