Hello all,
Please I need support relating a calculation I need to add in my dashboard refering to the achievement based on family products.
I have in the below table the daily sales revenues and in the last 3 columns the monthly target and based on these data I need to calculate the daily achievement vs target in % as well the remaining revenue vs target.
| Sales name | beyound Connectivity daily sales | fixed daily sales | Mobility daily sales | Beyound connectivity monthly target | Fixed monthly target | Mobility monthly target |
| Anela | 1500 | 0 | 0 | 78000 | 117500 | 40000 |
| Elma | 0 | 0 | 1500 | 90000 | 112500 | 38000 |
| Ornel | 1000 | 0 | 15417 | 75000 | 95000 | 38000 |
| Xhuljana | 0 | 1032 | 22750 | 75000 | 95000 | 38000 |
| Total | 4333 | 1032 | 42142 | 412000 | 535000 | 194000 |
Goga Team contains the Target revenues based on family and Ervis Goga monthly revenues contain the daily sales revenues.
Can you help me please?
Thank you!
The values mentioned 3000$ and 20000$ were just for sample explanation. Sorry for the inconvinience regarding that.
The real data are in the table sent on the first email.
Thank you!
Hi @Elyblog2009 ,
Frankly, I probably understand what you're trying to do, but I'm a bit elusive about your data. So I created my own samples that might be similar to your question to show:
TOTAL = CALCULATE(SUM('Date'[Value]),FILTER('Date',YEAR([Date])=YEAR(EARLIER([Date]))&&[Date]<=EARLIER([Date])))
Target % = DIVIDE([TOTAL],[Target])
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
Thank you for the example, but I think in my case is a little more complicated bcs First I need to have totals of revenue based on family products as below shown. I have created them on a visual by relationship and at this point I need that based on these values to match the target family target that is in another table or relate them somehow with a formula . That is what I am not figuring out so far.
| BSE | Month | Day | Year | Family | Sum of Monthly Fee |
| anela | July | 1 | 2024 | Mobility | 68625 |
| elma | July | 5 | 2024 | Mobility | 5000 |
| elma | July | 17 | 2024 | Fixed Connectivity | 2500 |
| elma | July | 17 | 2024 | Mobility | 15150 |
| ornel | July | 2 | 2024 | Mobility | 46668 |
| ornel | July | 17 | 2024 | Fixed Connectivity | 10000 |
| xhuljana | July | 12 | 2024 | Mobility | 163250 |
| xhuljana | July | 17 | 2024 | Beyond Connectivity | 105480 |
| xhuljana | July | 17 | 2024 | Fixed Connectivity | 13749 |
| xhuljana | July | 17 | 2024 | Mobility | 10000 |
| xhuljana | July | 18 | 2024 | Mobility | 6250 |
And in this table I need to add the achievement vs target that exist in the table below:
Tell me if
Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
