Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Use multiple values from the same table and summarize them on the same page

Hello,

 

I am in the process of calculating the price of concrete which is composed of a base price and a concrete mix. The base price is based on the concrete plant and can be found in the table 'tblConcrete plants'. The available concrete mixes and corresponding price can be found in the table 'tblCounter'.

 

Now I want page 1 to allow the user to select the concrete plant and associated base price. Page 2 selects the quantity of concrete (through a parameter field for more info see: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if) and the concrete mix. On page 3 this is also done with a new paramater to determine the quantity etc.

 

The measurement that calculates what the total price of a concrete mixture is as follows:

Price concrete 1 = [Value of TblInputConcrete1]*[Base Price + Additional cost of concrete mix]
Price concrete 2 = [Value of TblInputConcrete2]*[Base Price + Additional cost of concrete mix]
etc.

 

The base price and additional cost are calculated via: 

Base Price = [SelectedBasePrice]

Aditional Cost = [SelectedAdditional]

 

Next, how do I make sure that I can create one table on a separate page that contains all these concrete mix and prices? Below is an image of what it should look like. Hope someone can help me! PS I am Dutch so the images/tables are too

 

Description concrete mixAmountPrice per unitTotal price
C35/45 XA1 F5100€5,00€500,00
C30/35 XC0 F2250€4,00€500,00
Total  €1.000,00


Page 1 to select the concrete plant etc.

Page 2 to select the concrete mix and quantity

 

 

No Replies