cancel
Showing results 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

Anonymous
Not applicable

## Dynamic calculation

Hi team,

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.

Table slicer:

 SiteId Flag GENERAL 1 SERVICE 0

Table Cost value:

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

Table Quantity & expected result to apply:

 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

Please could you please be kind and help.

Regards,

Carmen

1 ACCEPTED SOLUTION
Community Support

Hi @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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Community Support

Hi @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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Announcements

#### 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.