need help to calculating report from selected filter

[assemomar]

Please if anyone can help me how to add new column in this report to calculate as following :

As marked in red box (from photo below) :

Column (OEE) some numbers have example (120, 140, 160) 

multiply by selected filter : Effectiveness ( AvailACility * ReliACility)

multiply by selected filter : Design Capacity(m3/hr)

result to be added in the new column as marked

Thank you for your good help.

Regards,,

[v-nmadadi-msft]

Hi @assemomar 

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

Thanks and regards

[v-nmadadi-msft]

Hi @assemomar 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @assemomar 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-nmadadi-msft · Accepted solution]

Hi @assemomar ,
Thanks for reaching out to the Microsoft fabric community forum.

For Design Capacity and Effectiveness, using SELECTEDVALUE is particularly important because it ensures that the measure returns the chosen value from the slicer if only one option is selected, and returns BLANK() otherwise. This prevents ambiguous results when multiple capacity values are in scope.

Design Capacity = SELECTEDVALUE(ProductionData[DesignCapacity])
Effectiveness = SELECTEDVALUE(ProductionData[Effectiveness])
New Result =

SUMX (

    ProductionData,

    ProductionData[OEE]

        * [Effectiveness]

        * [Design Capacity]

)

Finally, you can combine everything in a measure with SUMX, which iterates through your table, multiplies each row’s OEE with the currently selected Effectiveness and Design Capacity, and then sums the results. This approach avoids context-mixing errors, ensures slicers are respected, and gives you a calculation that adapts correctly to user selections.

I hope this information helps. Please do let us know if you have any further queries.
Thank you