Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Rule of three and Estimation Problem


I have a table with  Date  Store  StoreType and Cost



Store  Date  StoreType Sales  Cost 

1                  mine         known  known

2                notmine      known  unknown



and so on  


Then I use this table to create another table by grouping sale

the table look like this 



Table 2

Sales                                         Cost

10000 (avg 5000-15000)         5000

20000 (avg 15000-25000)       7000

30000 (avg 25000-35000)       10000

40000 (avg 35000-45000)       15000

50000 (avg 45000-55000)       20000


The problem is Some Store is not mine  I only know their sales not cost

So I want to  create measure that take Sales for the mentioned Store as input and calculate thier cost base on rule of three or any suggestion.  

for example  Sales = 15000 output cost should be 6000

                     Sales = 48000 output cost should be 19000


However Table Sales is updated every month, so I cant fix number in Table 2  and  need the measure to calculate cost for other store based on my store cost  and sales  for month by month. (use JAN data for calculate JAN cost).


Thank you in advance and sorry for any mistyping.









Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors