Calculate average based on same category
Hi Everyone, Good day! As per the below snapshot I want to create a new measure where the marked percentage numbers should get averaged beacuse it lies under the same category of column A but column B is divided into sub category so, I have to average those numbers but in the total section it should take one percentage (like 40.00% + 53.33% = 46.66% but in the total average calcualtion it should be considered once . Margin formula = c-d/d Thanks in advance, Sumesh
