Dynamic calculation

Question

Hi team,&nbsp;I have the following structure and need to apply custom calculation= Cost * Quantity depending of slicer selection.Cost is in one table, Quantity in another table.The relationship isn't made in PBI beacuse Cost table has always 2 rows for every ProductKey with the scope to avoid duplicate data.How can we calculate Cost *Quantity having these if any selection for General and for Service.&nbsp;Table slicer:SiteId&nbsp; &nbsp; &nbsp;FlagGENERAL&nbsp; &nbsp; 1SERVICE&nbsp; &nbsp; 0&nbsp;Table Cost value:ProductKey&nbsp;SiteId&nbsp;Cost10&nbsp;GENERAL&nbsp;10010&nbsp;SERVICE&nbsp;20020&nbsp;GENERAL&nbsp;30020&nbsp;SERVICE&nbsp;400&nbsp;Table Quantity &amp; expected result to apply:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; expected if slicer selection = GENERAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; expected if slicer selection = SERVICEProductKey&nbsp;WarehouseLocationQuantity&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Cost * Quantity10&nbsp;120&nbsp;5&nbsp;&nbsp;&nbsp; '=100 * 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '=200*510&nbsp;115&nbsp;10&nbsp;&nbsp;&nbsp; '=100*10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '=200*1020&nbsp;150&nbsp;15&nbsp;&nbsp;&nbsp; '=300*15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; '=400*15&nbsp;Please could you please be kind and help.&nbsp;Regards,Carmen

anonymous · Accepted Answer

Hi&nbsp;Anonymous,
You can create a what-if parameter and use it as the source of the slicer, then you can write a measure formula based on filter selection and current cost values to calculate.
SELECTEDVALUE function - DAX | Microsoft Docs
Use what-if parameters to visualize variables - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng

Forum Discussion

Dynamic calculation

1 Reply

Related content

Dynamic Rank Calculation

Dynamic Calculation Different Period

Dynamic Variable in Calculated Columns

Dynamic Calculation Group Item

Dynamic y-Axis calculation with Deneb

ProductKey	SiteId	Cost
10	GENERAL	100
10	SERVICE	200
20	GENERAL	300
20	SERVICE	400

				expected if slicer selection = GENERAL	expected if slicer selection = SERVICE
ProductKey	WarehouseLocation	Quantity	*Cost Quantity**
10	120		5	'=100 * 5	'=200*5
10	115		10	'=100*10	'=200*10
20	150		15	'=300*15	'=400*15