Forum Discussion
Divide in a table
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.
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 ) )
1 Reply
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 ) )