Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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 ) )
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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 ) )
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
78 | |
75 | |
62 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |