Forum Discussion
Calculating Monthly Percentage
I am working on a project to track the utilization of steel at our facility. What I am looking to do is calculate the monthly utilization percentage using the following equation: Total Used Steel (m^...
Need to use the SUM function in the measure. Essentially putting the calculation in the background as opposed to a setting on the card visual as you encountered.
%_Used = SUM(Sheet1[Total_used]) / SUM(Sheet1[Total_Steel])Once I had created those two columns, I created that as a measure (modeled as a %) for the card value.Then you should be able to use visual level filters to set your cards to the appropriate Month.I understand using that Steel # as a filter. That explains it, thank you. I was thinking of it more as a "Job" or Asset number instead of a classification.
TrentS How do I create a measure that can reference those columns? I tried that earlier and it wouldn let me do that. Also, the sheet column is the code for our steel chemistry. I'll use it in a slicer so we can see the utilization of different steels.
Need to use the SUM function in the measure. Essentially putting the calculation in the background as opposed to a setting on the card visual as you encountered.
%_Used = SUM(Sheet1[Total_used]) / SUM(Sheet1[Total_Steel])
Once I had created those two columns, I created that as a measure (modeled as a %) for the card value.
Then you should be able to use visual level filters to set your cards to the appropriate Month.
I understand using that Steel # as a filter. That explains it, thank you. I was thinking of it more as a "Job" or Asset number instead of a classification.