Divide in a table

[noamshn]

Hello everyone,

I created table vissualization like this:

i created week dates table and then i summed the Restricted and Production records from different table. in addition i created a slicer for a plant filter (the data is of plants production).

Right now i want to created another column which show precent of restricted, so the formula will be = restricted/(restricted + production).

the problem is that im not sure how to do it because its hard to create a meausre that will do this operation and will also take in consideration the week range and the plant.

I will be glad for some help here.

Thank you in advance.

[MFelix · Accepted solution]

Hi @noamshn ,

The context of the visualization will provide all the filters and values you need for the calculation.

Try the following measure:

% Resctricted = 
        VAR _Restricted = SUM(Table[Restricted])
        VAR _Production = SUM(Table[Production])
        RETURN
           DIVIDE(  _Restricted , (_Restricted  +_Production  ) )